Inserting a Table into a Database Example

The following example copies the CREATE TABLE statements for the customer table into the dbschema output file, tab.sql:

dbschema -d db -t customer > tab.sql

Remove the header information about dbschema from the output file, tab.sql, and then use DB–Access to re-create the table in another database, as follows:

dbaccess db1 tab.sql