When you are building SQL statements in DB/Assist, it may be helpful to get an overview of the table and view structure in your database. You can do so by selecting Database Ø Schema at any time during a DB/Assist session, except when another dialog box is open.
When you select Database Ø Schema, DB/Assist provides information about the following for each table and view in the connected database:
•Columns and attributes
•Indexes
•Primary/foreign key relationships
The following sections describe how you can get schema information about each of these database elements.