Question and Answer Database FAQ2154D.txt Sharing data dictionaries Category :Database/VCL Platform :All Product :All 32 bit Question: How do I share data dictionaries? Answer: The data dictionary is merely a table created in any database. To create, right click on the DB Explorer Dictionary tab, provide a unique dictionary name, select a database from the list to create the dictionary table in, provide a unique table name (you can leave BDESDD), and description is optional. Once the dictionary is created, you can see on the dictionary table exists on the Databases tab, under the database you specified. To share, the database and table specified in dictionary creation must exist in a shareable location, such as on an SQL server. At the second location, select from the Dictionary menu, Register. Provide any name for Dictionary name (using a company standard of some sort and everyone use the same name here is recommended), select the database table that contains the previously created dictionary table, table name, and description is once again optional. In cases where database tables are qualified with an owner name, the datadictionary table will also have this same feature/limitation. The same issue will be true for each table field being described -- i.e. if the field is myownerA.field1, table myownerb.field1 will not see the attributes described. 7/16/98 4:31:28 PM
Last Modified: 01-SEP-99