Each table has several names, a series, database type, table fields, keys, key options, segment options, and table relationships. Use the Table Definition window to view information about tables.
|
You can also use the Resource Descriptions tool to view information about tables. |
Three names are required for each table. The table name is the name that is used in scripts to refer to the table.
The display name is the name that appears when the name of the table is displayed on the screen in an application.
The physical name is the name under which the table is stored by the operating system or database. The appropriate extension, if required, is added automatically.
The table series groups related tables in the application together using series categories like Sales, Financial, and System.
Tables can use the following database types: c-tree Plus, Pervasive.SQL, and Microsoft SQL Server. If the setting Default is used, the application will determine which database type to use at runtime, based upon several system settings
These are the fields that are stored in the table. The Record Size field in the Table Definition window contains the total size of each record in the table.
Table relationships link related tables that share common information. Table relationships are required to allow the Report Writer to access information from multiple tables for a single report. Refer to Table Relationships for more information about creating and using table relationships.