Export (0) Print
Expand All

DROP INDEX

SQL Server 2000

Removes an index from the current database.

The DROP INDEX statement does not apply to indexes created by defining PRIMARY KEY or UNIQUE constraints (created by using the PRIMARY KEY or UNIQUE options of either the CREATE TABLE or ALTER TABLE statements). For more information about PRIMARY KEY or UNIQUE constraints, see CREATE TABLE.

Syntax
DROP INDEX 'table_name.index_name'  
Arguments
table_name
Is the name of the table in which the indexed column is located. Table names must conform to the rules for identifiers.
index_name
Is the name of the index to be dropped. Index names must conform to the rules for identifiers.
Remarks

After DROP INDEX is executed, all the space previously occupied by the index is regained. This space then can be used for any database object.

DROP INDEX cannot be specified on an index on a system table.

Show:
© 2014 Microsoft