DROP INDEX (TSQL Statement)

removes the specified index from the specified table.

Syntax

DROP INDEX index_name
    ON <table_qname>

<table_qname> ::= [ database_name. [ schema_name ] . | schema_name. ] table_name

Arguments

index_name
is the name of the index to drop.
<table_qname>
is the qualified or unqualified name of the table.

Remarks

Only sa or dbo is allowed to execute this statement.

It is not possible to drop a clustered index.

See also ALTER TABLE DROP which is equivalent.

Examples

DROP INDEX idx_name ON clients;