Example 1: Deleting a table from an attached database

    SQL> ATTACH 'ALIAS PERS FILENAME personnel';
    SQL> DROP TABLE PERS.DEGREES;
    SQL> COMMIT;

    Example 2: Deleting a table and definitions that reference it
    from the default database

    SQL> ATTACH 'FILENAME corporate_data';
    SQL> DROP TABLE ADMINISTRATION.PERSONNEL.EMPLOYEES CASCADE;
    View ADMINISTRATION.PERSONNEL.REVIEW_DATE is also being dropped.
    View ADMINISTRATION.PERSONNEL.CURRENT_INFO is also being dropped.
    View ADMINISTRATION.PERSONNEL.CURRENT_SALARY is also being dropped.
    View ADMINISTRATION.PERSONNEL.CURRENT_JOB is also being dropped.
    Constraint ADMINISTRATION.RECRUITING.DEGREES_FOREIGN2 is also being dropped.
    Constraint ADMINISTRATION.PERSONNEL.EMPLOYEES_PRIMARY_EMPLOYEE_ID is also
    being dropped.
    Constraint ADMINISTRATION.PERSONNEL.EMP_SEX_VALUES is also being dropped.
    Constraint ADMINISTRATION.PERSONNEL.HOURLY_HISTORY_FOREIGN1 is also being
    dropped.
    Constraint ADMINISTRATION.PERSONNEL.JOB_HISTORY_FOREIGN1 is also being
    dropped.
    Constraint ADMINISTRATION.RECRUITING.RESUMES_FOREIGN2 is also being dropped.
    Constraint ADMINISTRATION.PERSONNEL.SALARY_HISTORY_FOREIGN1 is also being
    dropped.
    Constraint ADMINISTRATION.PERSONNEL.STATUS_CODE_VALUES is also being dropped.
    Index ADMINISTRATION.PERSONNEL.EMP_LAST_NAME is also being dropped.
    Index ADMINISTRATION.PERSONNEL.EMP_EMPLOYEE_ID is also being dropped.
    Trigger ADMINISTRATION.PERSONNEL.EMPLOYEE_ID_CASCADE_DELETE is also being
    dropped.
    Trigger ADMINISTRATION.PERSONNEL.STATUS_CODE_CASCADE_UPDATE is also being
    dropped.