Table Tab, Table Designer

  • Article

The Table tab appears in the Table Designer. It contains read-only information about the table and areas for setting the record-level rule and validation error text, triggers, and comments.

Note   If you are modifying a Free table, only the read-only statistics for the table are displayed on this tab. Free tables cannot have associated rules, triggers, or comments.

  • Name
    Specifies the name of the table being created or modified.

    For database tables, the table name appears in the Project Manager; it is not the file name. Long names up to 128 characters are supported.

  • Database
    Displays the name of the database to which the table belongs if the table is not a free table. This box is read-only.

Statistics

Displays read-only about the table.

  • Table file
    Displays the path and file name for the table.
  • Records
    Displays the quantity of rows currently stored in the table.
  • Fields
    Displays the quantity of columns defined in the table structure.
  • Length
    Displays the length of the table.

Record Validation

Sets the row-level rule, validation error text, and a comment for the table. The button to the right of each setting displays the Expression Builder Dialog Box.

  • Validation Rule
    Specifies a record-level rule for enforcing data validation.
  • Validation Text
    Specifies the error message to be displayed if an entry fails to conform to the record-level validation rule.

Triggers

Specifies rules for updates, inserts, and deletes.

  • INSERT Trigger
    Specifies a rule to be triggered every time a record is inserted or appended to the table. Click the dialog button to display the Expression Builder Dialog Box.
  • UPDATE Trigger
    Specifies a rule to be triggered every time a record is updated in the table. Click the dialog button to display the Expression Builder Dialog Box.
  • DELETE Trigger
    Specifies a rule to be triggered every time a record is deleted from the table. Click the dialog button to display the Expression Builder Dialog Box.
  • Table Comment
    Provides space for you to type a comment about the table. Whatever you type here appears as the description at the bottom of Project Manager when this table is selected.

See Also

Expression Builder Dialog Box | FOR( ) Function | INDEX Command | SYS(14) - Index Expression | SYS(2021) - Filtered Index Expression | Table Tab, Table Designer | Table Wizard | Table Designer