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