Omnidex SQL: EXTRACT DDL

The OdxSQL EXTRACT Command will Extract DDL statements (CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE, CREATE INDEX and CREATE INDEX GROUP) or INSERT statements to a file. The extracted file can the be modified with an editor and used to build another Omnidex Environment.

  EXTRACT DDL [FOR <ENVIRONMENT [environment] | DATABASE database>]
    [TO filespec] [ON [INSTANCE] instance] [WITH options]
  EXTRACT [CLUSTERED] <INSERTS | UPDATES | DELETE_WHERES | DELETE_EXCEPTS>
    FROM tables [WHERE criteria] [TO filename]
    [ON [INSTANCE] instance] [WITH options]
    (Note: CLUSTERED requires tables to be one parent and any linked children)