Delete_Index subroutine
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: Value Description 1 - Btree index. 2 - Cross Reference index. 3 - Relational index. |
See Also
Create_Index, Update_Index
Example
From the command line:
run delete_index "CAR-PARTS"