Export (0) Print
Expand All
Expand Minimize
0 out of 4 rated this helpful - Rate this topic

DROP INDEX (SQL Server Compact Edition)

Removes an index from the current database.


DROP INDEX <table_name>.<index_name>
table_name

Specifies the name of the table on which to drop the index.

index_name

The index to drop.

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 (SQL Server Compact Edition).

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.