Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

Commands

Syntax

Options

Example

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

DELETEINDEX

Delete values directly from Omnidex indexes.

 

Syntax

DELETEINDEX FROM table [(column-list)] < VALUES (value-list) ROWID rowid [ON [INSTANCE] instance] [WITH options]

DELETEINDEX
Required

FROM table
Required - Specify the table to which the indexes belong.

[column-list]
Optional - Comma separate list of column whose index values are to be deleted.

< VALUES (value-list)

ROWID rowid

ON [INSTANCE] instance
Optional - The instance number on which to perform this command. If omitted, the current instance in the status array will be used.

[WITH options]
Optional - Specify options to be used for this command.

 

Options

 

 

Example

 

 

Top