Release 10.1A: OpenEdge Development:
Basic Database Tools

> ## Generating a detailed table report

> A detailed table report gives the following information for each table in the database:

> - Name

> - Description

> - Dump name

> - Flags

> - Field count

> - Index count

> - Labels

> - Storage area name

> - Trigger events

> - Trigger procedure filenames

> - A summary of each field, including:

> - Name
> - Order
> - Data type
> - Flags
> - Format
> - Initial value
> - Field label
> - Column label
> - A summary of each index, including:

> - Name
> - Flags
> - Count
> - Field name
> - Storage area
> - Details about each field, including:

> - Validation message.
> - Validation expression.
> - Description.
> - Help text.
> - Triggers.
> - Trigger procedure filenames.
> - Whether the field is overridable.
> - Whether to check the CRC.

> | To generate a detailed table report:

> 1. Choose Database Reports Detailed Table. The Data Dictionary alphabetically lists all the tables defined for your database.

> 2. Select a table or type ALL. The Report Options dialog box appears:

> 3. Specify the report destination. You can display the report on your terminal, print it, or save it to a file. If you want to save the report to a file, specify the filename and whether to append the report to an existing file.

> 4. Specify the page length.

> 5. Specify to order the fields by order number or alphabetically, then choose OK.

> If you specified a file or printer, the Data Dictionary generates the report to the specified output destination. The Data Dictionary main window then reappears.

> If you sent the report to the terminal, the Detailed Table Report dialog box appears. You can choose Change Field Order to reorder the fields, choose Print to print the report or write it to a file, or choose OK to close the Report Options dialog box.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095