To view the tables in a database:
To view the columns in a table:
The grid contains the following fields for each column in the table:
The length of the column in bytes. Used only for CHAR, VARCHAR, BIT, and BIT VARYING columns.
The number of significant digits. Used only for DECIMAL and NUMERIC columns.
The number of digits after the decimal point. Used only for DECIMAL and NUMERIC columns.
Optional value by which to increment an autoincrement field.
To view the indexes defined on a table:
A list of the table's indexes appears in the right panel.
For a more detailed view of indexes, do one of the following:
The right panel then displays three tabs:
In addition to indexes, you can view and define primary, unique, and foreign keys on a table.
To view the keys defined on a table:
For a more detailed view of a key, do one of the following:
The right panel then displays two tabs:
To see the check constraints defined on a table:
A list of the table's check constraints appears in the right panel.
For a more detailed view of check constraints, do one of the following:
The right panel then displays two tabs:
Shows the name of the check constraint and the condition it enforces
Shows the statements that can be used to create or delete the check constraint
You can modify the lock level for a table by clicking on the drop-down arrow.
To view the statement that created a table:
The statement that created the table appears in the right panel. Below it is the statement that can delete the table, as well as statements to create and delete any indexes, keys, and check constraints on the table. These statements are read-only; you cannot modify or run them from this window. However, you can copy them into the SQL field on the Database panel, where you can save, edit, and execute them (see Executing Statements from the SQL Window).
Version 5.2