Omnidex SQL Reference

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 ODXSQL program.

• ASSIGNVALUES <tab>(TODO)
• ATTACH <tab>(TODO)
• CLOSE CURSOR <tab>(TODO)
• command <tab>(TODO)
• CONNECT <tab>(TODO)
• CREATE DATABASE <tab>(TODO)
• CREATE DIRECTORY <tab>(TODO)
• CREATE ENVIRONMENT <tab>(TODO)
• CREATE FILE <tab>(TODO)
• CREATE INDEX <tab>(TODO)
• CREATE INDEXES <tab>(TODO)
• CREATE TABLE <tab>(TODO)
• DELETE <tab>(TODO)
• DELETEINDEX <tab>(TODO)
• DETACH <tab>(TODO)
• DISCONNECT <tab>(TODO)
• DROP DATABASE <tab>(TODO)
• DROP ENVIRONMENT <tab>(TODO)
• DROP INDEX <tab>(TODO)
• DROP INDEXES <tab>(TODO)
• DROP TABLE <tab>(TODO)
• EXPORT <tab>(TODO)
• HELPER <tab>(TODO)
• INSERT <tab>(TODO)
• INSERTINDEX <tab>(TODO)
• JOIN <tab>(TODO)
• LOAD OFX <tab>(TODO)
• OPEN CURSOR <tab>(TODO)
• PARTITION <tab>(TODO)
• QUALIFY <tab>(TODO)
• SELECT <tab>(TODO)
• SET <tab>(TODO)
• UPDATE <tab>(TODO)
• UPDATE INDEXES <tab>(TODO)
• UPDATE ROLLUP <tab>(TODO)
• UPDATE ROLLUPS <tab>(TODO)
• UPDATE STATISTICS <tab>(TODO)
• UPDATE TEXT <tab>(TODO)
• UPDATEINDEX <tab>(TODO)
• VERSION <tab>(TODO)