The Schema tab shows the structure of a table you select in DBView, including its columns, constraints, referencing constraints, and indexes.
View the schema
Select a table to populate the Schema grid.
You can use the Include deleted Records toggle to also display records that have been deleted from the table.
The Schema tab contains the following sub-tabs:
Columns: Displays data on the field order, name, type, size, and whether data is required in the field.
Constraints: Displays required links to supporting tables, such as lookups and child tables.
Referencing Constraints: Displays the tables that are referencing the selected table.
Indexes: Shows the defined indexes and the fields that are indexed.
Order data
Click a column header to order the data. The sort order changes with further clicks, cycling between Ascending, Descending, and None.
To order by multiple columns, hold down the SHIFT key while clicking the column headers.