Example 1: Deleting an index from the default database SQL> ATTACH 'FILENAME personnel'; SQL> DROP INDEX DEG_COLLEGE_CODE; SQL> COMMIT; Example 2: Deleting an index from one of several attached databases SQL> ATTACH 'FILENAME personnel'; SQL> ATTACH 'ALIAS MF FILENAME mf_personnel'; SQL> ATTACH 'ALIAS CORP FILENAME corporate_data'; SQL> SET QUOTING RULES 'SQL99'; SQL> DROP INDEX "CORP.ADMINISTRATION".PERSONNEL.EMP_EMPLOYEE_ID; SQL> COMMIT;