Data Dictionary

Previous  Top  Next


Reference > Data Dictionary

CISPro Global uses the data dictionary to configure and control data operations. The table DATA_DICTIONARY has a row for every column defined in a table in the database. This table should never be modified by anyone except ChemSW development staff or a system admin at the direction of ChemSW Support.

 

System administrators can view the data dictionary as a way to understand the database design and determine what columns exist in which tables for reporting and labeling queries.

 

To view the data dictionary:

1) Login in as a system administrator

2) Click the System Configuration link

3) Click the View Data Dictionary link

4) Select the table of interest and click Filter

 

clip0123

 

Filter

Will limit the rows displayed to a single table. Select a table from the dropdown list and click Filter.

 

All

Will reset the list to show all columns from all tables.

 

All Columns checkbox

Will display all columns for each row instead of just the simplified view of table, column, data type and size (length).