


Select the Object / New menu function and then Table from the submenu displayed, or click on the
toolbar button to enter design mode where you
can define a new table. Both operations are available in the object menu, object list, and relationship display.
The Table object describes an ADABAS table. A table is either a base, view, synonym, snapshot, or result table; i.e., the table list contains View, Synonym, and Snapshot objects ("type" column in the table list). Each user has defined access privileges (or none at all) for a specific table.
Relationships between tables and other objects
1. Table Contains Column
2. Table Uses Constraint
3. Table Contains Trigger
4. Easycommand Uses Table
5. Easyform Uses Table
6. Foreignkey Refers to Table
7. Module Uses Table
8. Qpcommand Uses Table
9. Qpquery Uses Table
10. Querycommand Uses Table
11. Snapshot Uses Table
12. Synonym Refers to Table
13. User Uses Table
14. View Uses Table
1. A table comprises one or more columns; each column is assigned to exactly one table (1-N).
2. A table can use a number of constraints; a constraint can be used by a number of tables (N[0]-M[0]).
3. A table can contain triggers; each trigger is assigned to exactly one table
(1-N[0]).
4. An EASY command uses one or more tables; a table can be used by an EASY command (N[0]-M).
5. An EASY form uses a table; a table can be used in an EASY form (N[0]-M).
6. A foreign key refers to exactly one primary table; the primary key for a table can be assigned to a foreign key of another table (0-1).
7. A module can use a number of tables; a table can be used by a number of modules (N[0]-M[0]).
8. A QueryPlus command uses one or more tables; a table can be used by a number of QueryPlus commands (N[0]-M).
9. A QueryPlus query uses one or more tables; a table can be used by a number of QueryPlus queries (N[0]-M).
10. A QUERY command uses one or more tables; a table can be used by a number of QUERY commands (N[0]-M).
11. A snapshot refers to one or more tables; a table can be used by a snapshot (N[0]-M).
12. A synonym refers to a base or view table; a number of synonym definitions can exist for a table (N[0]-1).
13. A user can use a number of tables; a table can be used by one or more users
(N-M[0]).
14. A view table refers to one or more tables; a table can be used by a view table (N[0]-M).
Example of a list of all tables for the user SQLTRAVEL00:

To create a new table, click on the
toolbar button or select the Object / New / Table menu item in the table's design mode.

The table definition comprises a number of parts:
- Columns
- Primary key
- Constraints
- Foreign keys
- Indexes
- Triggers
- Options
These components are displayed in the Table Design window on separate cardfile cards. In order to create a table, the Columns card must contain at least one definition; all the other cards can be blank.
A table is defined by filling out the cards entry by entry and in any order. You can repeat and correct this procedure as often as you wish and terminate it by selecting the Object / Save menu item. The table name is not entered until this point. If you exit design mode using the Object / Close function, DOMAIN asks whether the changes should be saved as a table definition.
See also:
Defining and Deleting Foreign Keys
Defining and Deleting an Index
Defining a Table Like Another Table (CREATE Table Like)
Managing Access Privileges for Tables
Statistical Information About Tables


