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