This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:commands:home [2009/12/28 17:40] tdo |
programs:odxsql:commands:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 28: | Line 28: | ||
| | [[dev:sql:statements:update:home |UPDATE]] | Issue an Omnidex SQL UPDATE Statement. | | | [[dev:sql:statements:update:home |UPDATE]] | Issue an Omnidex SQL UPDATE Statement. | | ||
| | [[dev:sql:statements:delete:home | DELETE]] | Issue the SQL DELETE Statement. | | | [[dev:sql:statements:delete:home | DELETE]] | Issue the SQL DELETE Statement. | | ||
| - | |||
| ===== Omnidex SQL Data Definition Language (DDL) Statements ===== | ===== Omnidex SQL Data Definition Language (DDL) Statements ===== | ||
| ^ DDL Statement ^ Description ^ | ^ DDL Statement ^ Description ^ | ||
| Line 42: | Line 41: | ||
| | [[programs:odxsql:commands:drop_index|DROP INDEX]] | Drop Index. | | | [[programs:odxsql:commands:drop_index|DROP INDEX]] | Drop Index. | | ||
| | [[programs:odxsql:commands:drop_indexes|DROP INDEXES]] | Drop Indexes. | | | [[programs:odxsql:commands:drop_indexes|DROP INDEXES]] | Drop Indexes. | | ||
| + | | [[programs:odxsql:commands:show_ddl|SHOW DDL]] | Show Data Definition Statements. | | ||
| + | |||
| ===== Additional Omnidex SQL DML Statements ===== | ===== Additional Omnidex SQL DML Statements ===== | ||
| Line 193: | Line 194: | ||
| | [[programs:odxsql:commands:set|SET]] | Both | Set an OdxSQL setting. | | | [[programs:odxsql:commands:set|SET]] | Both | Set an OdxSQL setting. | | ||
| | [[programs:odxsql:commands:show|SHOW]] | Command |Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | | | [[programs:odxsql:commands:show|SHOW]] | Command |Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | | ||
| + | | [[programs:odxsql:commands:show_ddl|SHOW DDL]] | Show Data Definition Statements. | | ||
| | [[programs:odxsql:commands:signal|SIGNAL]] | Command | Sends a Signal to a process. | | | [[programs:odxsql:commands:signal|SIGNAL]] | Command | Sends a Signal to a process. | | ||
| | [[programs:odxsql:commands:update|UPDATE]] | Statement | Issue an Omnidex SQL UPDATE Statement. | | | [[programs:odxsql:commands:update|UPDATE]] | Statement | Issue an Omnidex SQL UPDATE Statement. | | ||