This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:odxsql:commands:extract:home [2010/07/04 18:35] tdo |
dev:odxsql:commands:extract:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
<html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ====== Omnidex SQL: EXTRACT DDL ====== | + | ====== Omnidex SQL: EXTRACT (DDL and DML Statements) ====== |
{{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
+ | |||
===== Description ===== | ===== Description ===== | ||
The OdxSQL EXTRACT command will Extract DDL statements (CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE, CREATE INDEX and CREATE INDEX GROUP) from the currently connected Omnidex Environment to a file. The extracted file can then be modified with an editor and used to build another Omnidex Environment. | The OdxSQL EXTRACT command will Extract DDL statements (CREATE ENVIRONMENT, CREATE DATABASE, CREATE TABLE, CREATE INDEX and CREATE INDEX GROUP) from the currently connected Omnidex Environment to a file. The extracted file can then be modified with an editor and used to build another Omnidex Environment. | ||
Line 33: | Line 34: | ||
=== FROM table_specs ==== | === FROM table_specs ==== | ||
+ | FROM table_specs is one or more tables to use to generate the DML statements. | ||
Line 50: | Line 52: | ||
extract ddl to myenvnew.sql; | extract ddl to myenvnew.sql; | ||
- | Extract DDL to default extract.sql file. | + | Extract DDL to default extract.sql file. The extract.sql file must not exist. |
extract ddl; | extract ddl; | ||
Extract INSERT statements from a named table. | Extract INSERT statements from a named table. |