Table Report Help

The Table Report is a fully attributed HTML document providing table and column information.

In the sample Table Report, we see all the associated attributes for a given table. Sample Table Report

Table Name
The table name is at the upper left. It is followed by navigation links to the parts of that table.
Table-level Detail
Description and Definition: Documented descriptions of the table.
Table Type: Table classification of ACTIVITY (transactional data) or REFERENCE (DB Build table).
Column Detail Section
Column Name: The columns that appear on the table.
Type: The DBMS data type for the column.
Null: Displays whether or not a column allows a null value.
Definition: The documented definition of the column.
Relationship Detail
Parent section: If there are parents to this table as defined by a DBMS constraint, this list contains all the parent tables, the column name in those parent tables, and the name of the related column in this table.
Child section: If there are children to this table as defined by a DBMS constraint, this contains all the child tables and the related foreign key column name in those child tables.