Table Editor

Use this editor to define and maintain table definitions and the corresponding DAL scripts.

Tables are data structures used to store data that consists of a list of records, with each entry identified by a unique key and containing a set of related values. A table contains a number of table fields that belong to a specific domain.

Table definitions describe the record fields and the field domains. A table definition shows the following properties:


Table	The name of the table.
Label Name	The name of the label that contains the description of the table.
Description	The description of the table.
Update Ref. Message	The message that appears when you change a record referenced by other records.
Delete Ref. Message	The message that appears when you delete a record referenced by other records.
Relation Type	How table fields are mutually dependent.
Table Fields	The record attributes.
Table Indices	The index fields and their sequence.
Table Script	The Data Access Layer (DAL) script that applies to this table. A DAL script is used to authorize data access and to ensure data integrity.

See Table definitions.

Note: If you are not authorized to change the data model, you can only edit the table's DAL script. See the descriptions of the Script and Source tabs.