Removes a Btree, Cross Reference, or Relational index from a specified column in a table.
Delete_Index(tablename, columnname, indextype)
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. |
Create_Index, Update_Index
From the command line:
run delete_index "CAR-PARTS"