Database Schema Report
The Database Schema Report lists a specified range of the database schema. To print the report, specify a database table name (for example, apparms) or range of names in the starting and ending Table fields.
The first selected database table and its description displays on the top line of the report.
Next, all indexes for the table are listed. Primary keys are prefixed by PK_. Secondary indexes are prefixed by IX_.
Then all columns within the current table are listed, sorted by the column number (which is roughly the order in which the column was added to the table). For each column, this information is provided:
- user-defined data type
- data type
- length
- precision
- scale
- field description
The list of tables displays in alphabetic order.