STV_Drop_Index
Deletes a spatial index. If STV_Drop_Index cannot find the specified spatial index, it returns an error.
The OVER clause must be empty.
Behavior Type
Syntax
STV_Drop_Index( USING PARAMETERS index =
'index_name' ) OVER ()
Arguments
index = 'index_name' |
Name of the index, type VARCHAR. Index names cannot exceed 110 characters. The slash, backslash, and tab characters are not allowed in index names. |
Example
The following example shows how to use STV_Drop_Index.
Drop an index:
=> SELECT STV_Drop_Index(USING PARAMETERS index ='my_polygons') OVER (); drop_index ------------ Index dropped (1 row)