Display database definition
You can use this function to display the details of all tables and fields in the database on a single data entry form. This is useful when the database was not originally created in Surpac and you are not familiar with its structure, or when you have forgotten what tables and fields are in the database.
Prerequisites: A database is open.
To run this function: Choose Database > Database > Display database definition, or Design > Blast design > Database > Display database definition, or...
- In the Function Chooser, type DISPLAY DATABASE DEFINITION, and press ENTER.
Fields on the Display database definition form
| Field | Description |
|---|---|
| [table and field list] | The top part of the form lists all the fields in the database, their data types and the other details that collectively form the database schema. |
| Save Database Definition |
|
| Report File name | The name of the report. |
| Report File Format | The file format, and file extension, of the report. |
Output
If Save Database Definition is selected, a report is created that shows the database schema.