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)