SQL Commands

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.

SET

Set options for the current process.

UPDATE

Update rows in a table.

UPDATEINDEX

Update indexes directly.

VERSION

Get version information.

WITH

Specify options for the current command.

top