This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:odxsql:commands:extract:home [2010/07/04 18:21] tdo |
dev:odxsql:commands:extract:home [2010/07/04 18:29] tdo |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| If the TO filespec clause is omitted, then the file will be written to extract.sql in the current working directory. | If the TO filespec clause is omitted, then the file will be written to extract.sql in the current working directory. | ||
| - | |||
| ==== WITH options ==== | ==== WITH options ==== | ||
| Line 39: | Line 38: | ||
| Deletes the file specified in the TO filespec clause or the default extract.sql file if no filespec is specified in order to create a new file with the current SQL statement information. | Deletes the file specified in the TO filespec clause or the default extract.sql file if no filespec is specified in order to create a new file with the current SQL statement information. | ||
| + | extract ddl to myenv.sql with delete; | ||
| ===== Examples ===== | ===== Examples ===== | ||
| + | Extract DDL CREATE statements from a connected Environment. | ||
| connect myenv.xml; | connect myenv.xml; | ||
| extract ddl to myenvnew.sql; | extract ddl to myenvnew.sql; | ||
| - | extract ddl to myenv.sql with delete; | + | Extract DDL to default extract.sql file. |
| + | extract ddl; | ||
| + | Extract INSERT statements from a named table. | ||
| + | extract inserts from table1 to table1_inserts.sql; | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||