Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  DROP  INDEX  Examples
    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;
Close Help