This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:home [2010/07/09 01:50] tdo |
dev:sql:home [2012/10/26 14:51] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Omnidex SQL Statement Quick Reference ====== | ====== Omnidex SQL Statement Quick Reference ====== | ||
| - | [[dev:sql:home|Statements]] | [[dev:sql:functions|Functions]] | [[dev:sql:datatypes|Datatypes]] | [[dev:sql:examples | Examples]] | + | [[dev:sql:home|Statements]] | [[dev:sql:functions:home|Functions]] | [[appendix:reference:datatypes|Datatypes]] | [[dev:sql:examples:home | Examples]] |
| ^ Omnidex SQL Statements ^^ | ^ Omnidex SQL Statements ^^ | ||
| - | |**Connections** |**Data Definition** | | + | ^[[dev:sql:statements:connections:home | Connections ]] ^[[dev:sql:statements:ddl:home | Data Definition ]] ^ |
| |[[dev:sql:statements:connect:home|CONNECT]] |[[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | | |[[dev:sql:statements:connect:home|CONNECT]] |[[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | | ||
| |[[dev:sql:statements:disconnect:home|DISCONNECT]] |[[dev:sql:statements:create_database:home|CREATE DATABASE]] | | |[[dev:sql:statements:disconnect:home|DISCONNECT]] |[[dev:sql:statements:create_database:home|CREATE DATABASE]] | | ||
| Line 13: | Line 13: | ||
| |[[dev:sql:statements:detach:home|DETACH]] |[[dev:sql:statements:create_index_group:home|CREATE INDEX GROUP]] | | |[[dev:sql:statements:detach:home|DETACH]] |[[dev:sql:statements:create_index_group:home|CREATE INDEX GROUP]] | | ||
| | |[[dev:sql:statements:drop_environment:home|DROP ENVIRONMENT]] | | | |[[dev:sql:statements:drop_environment:home|DROP ENVIRONMENT]] | | ||
| - | |**Queries and Exports** |[[dev:sql:statements:drop_database:home|DROP DATABASE]] | | + | ^**Queries and Exports** |[[dev:sql:statements:drop_database:home|DROP DATABASE]] | |
| |[[dev:sql:statements:select:home|SELECT]] |[[dev:sql:statements:drop_table:home|DROP TABLE]] | | |[[dev:sql:statements:select:home|SELECT]] |[[dev:sql:statements:drop_table:home|DROP TABLE]] | | ||
| |[[dev:sql:statements:export:home|EXPORT]] |[[dev:sql:statements:drop_index:home|DROP INDEX]] | | |[[dev:sql:statements:export:home|EXPORT]] |[[dev:sql:statements:drop_index:home|DROP INDEX]] | | ||
| |[[dev:sql:statements:open_cursor:home|OPEN CURSOR]] |[[dev:sql:statements:drop_index_group:home|DROP INDEX GROUP]] | | |[[dev:sql:statements:open_cursor:home|OPEN CURSOR]] |[[dev:sql:statements:drop_index_group:home|DROP INDEX GROUP]] | | ||
| - | |[[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] |[[dev:sql:statements:extract:home|EXTRACT]] | | + | |[[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] |[[dev:odxsql:commands:extract:home|EXTRACT]] | |
| - | |. | | | + | |. | | |
| - | |**Updates** |**Maintenance** | | + | ^**Updates** ^**Maintenance** ^ |
| |[[dev:sql:statements:insert:home|INSERT]] |[[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | | |[[dev:sql:statements:insert:home|INSERT]] |[[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | | ||
| |[[dev:sql:statements:delete:home|DELETE]] |[[dev:sql:statements:update_rollups:home|UPDATE ROLLUPS]] | | |[[dev:sql:statements:delete:home|DELETE]] |[[dev:sql:statements:update_rollups:home|UPDATE ROLLUPS]] | | ||
| |[[dev:sql:statements:update:home|UPDATE]] |[[dev:sql:statements:update_statistics:home|UPDATE STATISTICS]] | | |[[dev:sql:statements:update:home|UPDATE]] |[[dev:sql:statements:update_statistics:home|UPDATE STATISTICS]] | | ||
| | |[[dev:sql:statements:update_text:home|UPDATE TEXT]] | | | |[[dev:sql:statements:update_text:home|UPDATE TEXT]] | | ||
| - | |**Omnidex Index Queries** |[[dev:sql:statements:partition:home|PARTITION]] | | + | ^**Omnidex Index Queries** |[[dev:sql:statements:partition:home|PARTITION]] | |
| |[[dev:sql:statements:qualify:home|QUALIFY]] |[[dev:sql:statements:load_ofx:home|LOAD OFX]] | | |[[dev:sql:statements:qualify:home|QUALIFY]] |[[dev:sql:statements:load_ofx:home|LOAD OFX]] | | ||
| |[[dev:sql:statements:join:home|JOIN]] |[[dev:sql:statements:install_indexes:home|INSTALL INDEXES]] | | |[[dev:sql:statements:join:home|JOIN]] |[[dev:sql:statements:install_indexes:home|INSTALL INDEXES]] | | ||
| Line 31: | Line 31: | ||
| \\ | \\ | ||
| \\ | \\ | ||
| + | |||
| ====== Omnidex SQL Statement Descriptions ======= | ====== Omnidex SQL Statement Descriptions ======= | ||
| Line 37: | Line 38: | ||
| ^Statement ^Description ^ | ^Statement ^Description ^ | ||
| | || | | || | ||
| - | |**Connections** || | + | ^**Connections** ^^ |
| | [[dev:sql:statements:connect:home|CONNECT]] | Connect to an Omnidex Environment. | | | [[dev:sql:statements:connect:home|CONNECT]] | Connect to an Omnidex Environment. | | ||
| | [[dev:sql:statements:disconnect:home|DISCONNECT]] | Disconnect from a connected Omnidex Environment. | | | [[dev:sql:statements:disconnect:home|DISCONNECT]] | Disconnect from a connected Omnidex Environment. | | ||