Dropping Indexes

Indexes can be dropped through the Indexes/Keys tab in Table Designer, or by using the DROP INDEX command. Indexes created by Primary Key or Unique Constraints can't be dropped in this manner; see Chapter 14 for more information.

When dropping indexes with DROP INDEX, multiple indexes can be specified in a single statement. The command for dropping indexes is as follows:

DROP INDEX emp_tel_idx, emp_idx1, emp_idx2 

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features