DB/Assist displays schema information for tables and views in the Database Schema dialog box The following table describes the column attributes shown in the Database Schema dialog box for each table and view in the connected database. (For an illustration of the Database Schema dialog box, see below.)
Column Attribute |
Description |
Key |
Indicates whether the column is a primary key (PK), foreign key FK), or both a primary key and foreign key (PK/FK). If the Key column is blank, the column is neither a primary key nor a foreign key. |
Column |
Specifies the column name. |
Type |
Specifies the data type of the column. |
Length |
Specifies the column length. |
Scale |
Specifies the scale; that is, the number of places to the right of the decimal in decimal numbers. |
Null |
Indicates whether the column allows null values (Y) or prohibits null values (N). |
To display column information for tables and views, follow these steps:
1.If you have not already done so, connect to your target database by creating a new SAM or opening an existing SAM.
If you need information about creating or opening a SAM, see Managing SQL Access Modules.
1.Select Database Ø Schema.
The Database Schema dialog box appears, as shown below.
Database Schema Dialog Box
2.If the name of the table you want to display does not already appear in the Table/View field, select it from the Table/View drop-down list.
The display changes to show the columns in the table you selected.
3.Select the Close push button or double-click on the system menu to close the dialog box.
You can also use the Database Schema dialog box to get information about indexes, as described in Examining Indexes, and primary/foreign key relationships, as described in Examining Primary/Foreign Key Relationships.
