Display FIMS Tables and Fields

Article summary

Did you find this summary helpful?

Thank you for your feedback

Display FIMS Tables and Fields

Display FIMS Tables and Fields located in Tools\System Utilities\System Reports shows FIMS database tables and table columns based on the selection.

Check the All checkbox to show all tables
If you un-check the All checkbox, you can select a range of tables.
Make any other selections needed such as showing used tables and fields or SQL tables.
Click OK to run report.

Field	Description
All Tables	If checked, all tables will be reported.
Tables From	A drop-down with table name to select starting table to report on. Used to restrict the range of table to report on.
Through	A drop-down with table name to select starting table to report on. Used to restrict the range of table to report on.
Show Unused Tables and Fields	A checkbox toggling the option to skip or show tables and fields that are not in use.
Show Progress System Tables	A checkbox toggling the option to skip or show non-FIMS (Progress) system tables.
Show SQL Tables	A checkbox toggling the option to skip or show SQL (logical / virtual) tables.
Show Indexes	A checkbox toggling the option to skip or show database table indices.
Sorting Alpha	Selecting this radio button will display the information in alphabetic order.
Order	Selecting this radio button will display the information in the natural order the information is stored internally.

Was this article helpful?