Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

SQL Reference

SQL Reference

SELECT Statement

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

Commands

ASSIGNVALUES
Use an undetermined set of values as criteria in a query.

ATTACH
Attach an OST (Omnidex Standalone table) to an open environment for queries and manipulation.

CONNECT
Connect to an Omnidex environment catalog.

CREATE TABLE
Create a new table in a database.

DELETE
Delete rows from a table.

DETACH
Detach an OST (Omnidex Standalone table) from an open environment.

DISCONNECT
Disconnect from an Omnidex environment catalog.

DROP TABLE
Drop a table created with a CREATETABLE or SELECT INTO command.

EXPORT
Export rows or rowids to an external file.

INSERT
Insert rows into a table.

INSERTINDEX
Insert indexes into the Omnidex index file.

JOIN
Manually join two tables for a joined query.

ON cursor/instance
Specify the cursor or instance to be used for the current command.

QUALIFY
Qualify rows in a query.

SELECT
Select rows in a query.

UPDATE
Update rows in a table.

UPDATEINDEX
Update indexes directly.

VERSION
Get version information.

WITH
Specify options for the current command.

Top