Delete_Index subroutine [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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|Create_Index]], Update_Index
 
==== Example ====
 
From the command line:
 
<code>
run delete_index "CAR-PARTS"
</code>