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;