Delete an index.

 

Syntax

 

<drop index statement> ::=

 

 

 

DROP INDEX [ IF EXISTS ] [ schema-name. ] table-name.index-name

 

 

Usage

 

The DROP INDEX statement deletes the index specified by index-name from the table.

 

 

Notes

 

The current database is implicit if a schema name is not specified.



 

The IF EXISTS clause can be specified to avoid an exception when attempting to delete an index that does not exist.



 

Deleting a UNIQUE index will automatically remove the associated table constraint.



 

The DROP INDEX statement requires exclusive access to the table on which the index being deleted is defined.



 

 

Examples

 

1)

The following example deletes the ix_studentName index from the students table:



 


DROP INDEX IF EXISTS students.ix_studentName



 

 


 

Conformance

 

NexusDB extensions

-

-

DROP INDEX statement

IF EXISTS clause