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:

  • The user-defined data type
  • The data type
  • The length
  • Any precision
  • Any scale
  • The field description

The list of tables displays in alphabetic order.