This shows you the differences between two versions of the page.
|
dev:sql:overview [2009/11/29 22:34] tdo |
dev:sql:overview [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex SQL Reference ====== | ||
| - | ===== Overview ===== | ||
| - | Omnidex SQL is a rich implementation of the SQL2 and SQL99 standards along with extensions specific to Omnidex. | ||
| - | Omnidex SQL statements can be tested and scripted using the [[programs:odxsql:overview|ODXSQL]] program. | ||
| - | |||
| - | ===== Statements by Type ===== | ||
| - | ==== Data Manipulation Statements ==== | ||
| - | | SELECT | Select data | | ||
| - | | INSERT | Insert data | | ||
| - | | DELETE | Delete data | | ||
| - | | UPDATE | Update data | | ||
| - | | QUALIFY | Qualify rows using Omnidex criteria | | ||
| - | |||
| - | ==== Index Manipulation Statements ==== | ||
| - | | | | | ||
| - | ==== Miscellaneous Statements ==== | ||
| - | ===== All Statements ===== | ||
| - | |||
| - | * [[dev:sql:assignvalues|ASSIGNVALUES]] <tab>(TODO) | ||
| - | * [[dev:sql:attach|ATTACH]] <tab>(TODO) | ||
| - | * [[dev:sql:close_cursor|CLOSE CURSOR]] <tab>(TODO) | ||
| - | * [[dev:sql:command|command]] <tab>(TODO) | ||
| - | * [[dev:sql:connect|CONNECT]] <tab>(TODO) | ||
| - | * [[dev:sql:create_database|CREATE DATABASE]] <tab>(TODO) | ||
| - | * [[dev:sql:create_directory|CREATE DIRECTORY]] <tab>(TODO) | ||
| - | * [[dev:sql:create_environment|CREATE ENVIRONMENT]] <tab>(TODO) | ||
| - | * [[dev:sql:create_file|CREATE FILE]] <tab>(TODO) | ||
| - | * [[dev:sql:create_index|CREATE INDEX]] <tab>(TODO) | ||
| - | * [[dev:sql:create_indexes|CREATE INDEXES]] <tab>(TODO) | ||
| - | * [[dev:sql:create_table|CREATE TABLE]] <tab>(TODO) | ||
| - | * [[dev:sql:delete|DELETE]] <tab>(TODO) | ||
| - | * [[dev:sql:deleteindex|DELETEINDEX]] <tab>(TODO) | ||
| - | * [[dev:sql:detach|DETACH]] <tab>(TODO) | ||
| - | * [[dev:sql:disconnect|DISCONNECT]] <tab>(TODO) | ||
| - | * [[dev:sql:drop_database|DROP DATABASE]] <tab>(TODO) | ||
| - | * [[dev:sql:drop_environment|DROP ENVIRONMENT]] <tab>(TODO) | ||
| - | * [[dev:sql:drop_index|DROP INDEX]] <tab>(TODO) | ||
| - | * [[dev:sql:drop_indexes|DROP INDEXES]] <tab>(TODO) | ||
| - | * [[dev:sql:drop_table|DROP TABLE]] <tab>(TODO) | ||
| - | * [[dev:sql:export|EXPORT]] <tab>(TODO) | ||
| - | * [[dev:sql:helper|HELPER]] <tab>(TODO) | ||
| - | * [[dev:sql:insert|INSERT]] <tab>(TODO) | ||
| - | * [[dev:sql:insertindex|INSERTINDEX]] <tab>(TODO) | ||
| - | * [[dev:sql:join|JOIN]] <tab>(TODO) | ||
| - | * [[dev:sql:load_ofx|LOAD OFX]] <tab>(TODO) | ||
| - | * [[dev:sql:open_cursor|OPEN CURSOR]] <tab>(TODO) | ||
| - | * [[dev:sql:partition|PARTITION]] <tab>(TODO) | ||
| - | * [[dev:sql:qualify|QUALIFY]] <tab>(TODO) | ||
| - | * [[dev:sql:select|SELECT]] <tab>(TODO) | ||
| - | * [[dev:sql:set|SET]] <tab>(TODO) | ||
| - | * [[dev:sql:update|UPDATE]] <tab>(TODO) | ||
| - | * [[dev:sql:update_indexes|UPDATE INDEXES]] <tab>(TODO) | ||
| - | * [[dev:sql:update_rollup|UPDATE ROLLUP]] <tab>(TODO) | ||
| - | * [[dev:sql:update_rollups|UPDATE ROLLUPS]] <tab>(TODO) | ||
| - | * [[dev:sql:update_statistics|UPDATE STATISTICS]] <tab>(TODO) | ||
| - | * [[dev:sql:update_text|UPDATE TEXT]] <tab>(TODO) | ||
| - | * [[dev:sql:updateindex|UPDATEINDEX]] <tab>(TODO) | ||
| - | * [[dev:sql:version|VERSION]] <tab>(TODO) | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||