Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Schema Statements >

DROP INDEX statement

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

DROP INDEX statement

button_main button_prev button_next

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.

nexus_logo