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
|