Kbase P64494: What reports can be run from Data Dictionary
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
What reports can be run from Data Dictionary
FIX:
Under the Database Menu in Data Dictionary the following reports can be run:
1. Detailed Table: Displays structure of selected table (or all tables), related fields, triggers and sequences defined for the table.
2. Quick Table: Display summary information about each table in the database.
3. Quick Field: Display information about the structure of the selected field(s) by showing data type, format, and order name.
4. Quick Index: Provides information about one or all indexes. It shows name of the index, the fields that define the index and whether the index is primary, unique, word or abbreviated or inactive.
5. PRO/SQL View: Shows the name, whether it can be updated, base table name and view definition.
6, Sequence: Information includes name of sequence, initial value, incremental value, min/max values and whether it will stop and recycle at its maximum value.
7. Trigger: Among the information displayed are the tables and fields that have a trigger, and the type of event that causes the trigger to fire
8. User: Displays list of users who have permission to access the database and identifies whether the user has a password.
9. Table Relations: Shows the implicit join relations for one or more tables in the database.
10. Storage Areas: Provides list of all storage areas in working database, storage area number, type, block size, total extents and area name.