Inserting a table into a dbschema output file

You can insert CREATE TABLE statements into the dbschema output file and use this output as DB-Access input.

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

Copyright© 2018 HCL Technologies Limited