The tables module
- UpdatedAug 3, 2023
- 1 minute read
- Vancouver
- Table Administration
The Tables [sys_db_object] table contains a record for each table in the database.
To view the list of tables, navigate to .
To open the record for an existing table, click a table label. You can:
- View, add, or modify columns with a searchable and sortable embedded list, define the auto-number format, make the table extendable by other tables, and create modules for the table.
- Launch a schema map for a table by clicking the Show Schema Map related link.
- Open the dictionary entries for the table by right-clicking the form header and selecting Show Dictionary Record.
- Navigate directly to the default list or form view for the table by clicking the Show List or Show Form related link.
- Delete all records from a table by clicking the Delete All Records.
Related Content
- Schema map for tables
The schema map displays the details of tables and their relationships in a visual manner, allowing administrators to view and easily access different parts of the database schema.
- System dictionary
The system dictionary is a table, called Dictionary Entry [sys_dictionary], that contains details for each table and the definition for every column on each table in an instance.
- Delete all records from a table
You may decide to delete all the records on a table without deleting the table itself. For example, the administrator may want to delete all incidents on a test instance without deleting the incident table itself.
- Table administration
A table is a collection of records in the database. Each record corresponds to a row in a table, and each field on a record corresponds to a column on that table.