Description
Removes a Btree, Cross Reference, or Relational index from a specified column in a table.
Syntax
Delete_Index(tablename, columnname, indextype)
Parameters
The Delete_Index subroutine has the following parameters.
Parameter | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
tablename | Specifies the name of the table containing the column from which an index is to be removed. | ||||||||
columnname | The name of the column from which to remove an index. If null, all indexes for the specified table are removed. | ||||||||
indextype | Type of index to remove:
|
See also
Example
From the command line:
run delete_index "CAR-PARTS"