DROP INDEX statement

Wed, 03/04/2009 - 20:02 |  hdanzl

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
‹ DROP TABLE statementupDROP VIEW statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Schema Statements

Powered by Drupal and Drupal Theme created with Artisteer.