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.

ParameterDescription
tablenameSpecifies the name of the table containing the column from which an index is to be removed.
columnnameThe 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:

ValueDescription
1Btree index.
2Cross Reference index.
3Relational index.

See also

Create_IndexUpdate_Index

Example

From the command line:

run delete_index "CAR-PARTS"
  • No labels