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 | ||
———————————————————- | ——————————————————— | ———————————————————- |