NexusDB V3 Manual
DROP INDEX statement
|
|
NexusDB Manual V3 > SQL Reference > SQL Statements > Schema Statements
|
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
|
|
© Nexus Database Systems Pty Ltd.