drop index

Description

Removes an index from a table in the current database.

Syntax

drop index table_name.index_name 
	[, table_name.index_name] ...

Parameters

table_name

is the table in which the indexed column is located. The table must be in the current database.

index_name

is the index to drop. In Transact-SQL, index names need not be unique in a database, though they must be unique within a table.

Examples

Example 1

Removes au_id_ind from the authors table:

drop index authors.au_id_ind 

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

drop index permission defaults to the index owner and is not transferable.

See also

Commands create index

System procedures sp_cursorinfo, sp_helpindex, sp_spaceused