This is an old revision of the document!
Statements | Functions | Datatypes | Examples
| Omnidex SQL Statements | |
|---|---|
| Connections | Data Definition |
| CONNECT | CREATE ENVIRONMENT |
| DISCONNECT | CREATE DATABASE |
| SET | CREATE TABLE |
| ATTACH | CREATE INDEX |
| DETATCH | CREATE INDEX GROUP |
| DROP ENVIRONMENT | |
| Queries and Exports | DROP DATABASE |
| SELECT | DROP TABLE |
| EXPORT | DROP INDEX |
| OPEN CURSOR | DROP INDEX GROUP |
| CLOSE CURSOR | EXTRACT |
| . | |
| Updates | Maintenance |
| INSERT | UPDATE INDEXES |
| DELETE | UPDATE ROLLUPS |
| UPDATE | UPDATE STATISTICS |
| UPDATE TEXT | |
| Omnidex Index Queries | PARTITION |
| QUALIFY | LOAD OFX |
| JOIN | INSTALL INDEXES |
| REMOVE INDEXES | |
| —————————————————————————————- | ————————————————————————————— |
| Omnidex SQL Statements | ||
|---|---|---|
| Connections | Omnidex Index Queries | Data Definition |
| CONNECT | QUALIFY | CREATE ENVIRONMENT |
| DISCONNECT | JOIN | CREATE DATABASE |
| SET | CREATE TABLE | |
| Maintenance | CREATE INDEX | |
| Queries and Exports | UPDATE INDEXES | CREATE INDEX GROUP |
| SELECT | UPDATE ROLLUPS | DROP ENVIRONMENT |
| EXPORT | UPDATE STATISTICS | DROP DATABASE |
| OPEN CURSOR | UPDATE TEXT | DROP TABLE |
| CLOSE CURSOR | PARTITION | DROP INDEX |
| LOAD OFX | DROP INDEX GROUP | |
| Updates | INSTALL INDEXES | ATTACH |
| INSERT | REMOVE INDEXES | DETATCH |
| DELETE | EXTRACT | |
| UPDATE | ||
| ———————————————————- | ——————————————————— | ———————————————————- |