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
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
