Specifications

CHAPTER 3 Managing the Database
Users Guide 95
Exporting table syntax
You can export the syntax for a table to the log. This feature is useful when you
want to create a backup definition of the table before you alter it or when you
want to create the same table in another DBMS.
To export to another DBMS, you must have the InfoMaker interface for that
DBMS.
❖ To export the syntax of an existing table to a log:
1 Select the table in the Objects or Object Layout view.
2 Select Export Syntax from the Object menu or the pop-up menu.
If you selected a table and have more than one DBMS interface installed,
the DBMS dialog box displays. If you selected a view, InfoMaker
immediately exports the syntax to the log.
3 Select the DBMS to which you want to export the syntax.
4 If you selected ODBC, specify a data source in the Data Sources dialog
box.
5 Supply any information you are prompted for.
InfoMaker exports the syntax to the log. Extended attribute information
(such as validation rules used) for the selected table is also exported. The
syntax is in the format required by the DBMS you selected.
For more information about the log, see “Logging your work” on page 82.
About system tables
Two kinds of system tables exist in the database:
• System tables provided by your DBMS (for more information, see your
DBMS documentation)
• InfoMaker extended attribute system tables
About InfoMaker
system tables
InfoMaker stores extended attribute information you provide when you create
or modify a table (such as the text to use for labels and headings for the
columns, validation rules, display formats, and edit styles) in system tables.
These system tables contain information about database tables and columns.
Extended attribute information extends database definitions.