Skip to content

Database Reports

Table Definition Report

This report prints a formatted version of the columns, index, and parameter information.

Percentage Filled Report

This report compares the number of rows with the defined 'At least # records' for each table.

Check for Orphans Report

This report checks the selected tables for orphaned rows. The report returns the RowId of any orphaned records in the selected tables. The returned RowId(s) can then be used to write a program that can find the orphaned records in question and perform any necessary maintenance or other work on those records.

See Also

Check Relationships Report

This report performs a full check of all table relationships. The following tests are made, and all mismatches reported:

  • The length and type of each relating column are compared with those of each related-to column.
  • The tables to which the tested table relates are compared with those listed in the table's relationship structure.
  • The tables relating to the tested table are compared with those listed in the child table's relationship structure.

Check for Damaged Headers Report

This report shows if the file headers are OK.

See Also