Skip to content

Table Schemas

With a table selected in the sidebar, the Schema tab shows information about the structure (schema) of a particular table.

Table schema view

In the image above, we have the person table selected and the bottom section is showing the SQL view for the table.

Columns

The upper part of the window shows a list of the columns making up the person table. Columns have a name, a type and sometimes constraints.

Constraints that are inactive are shown in a faded appearance. Clicking on an active constraint will show more information about it.

SQL view

Selecting the SQL view for the bottom section will show the CREATE TABLE command for this table. For information on creating or editing tables, see this page.

Indexes

Selecting the Indexes view for the bottom section will show information about indexes on the selected table. There is a detailed help page for indexes.

Table constraints

Some constraints don't have to be created as part of a column, but can declared separately. Selecting the Constraints view for the bottom section will list information about any table constraints.

Triggers

Selecting the Indexes view for the bottom section will show information about indexes on the selected table. There is a detailed help page for triggers.