SQL$HELP_OLD72.HLB  —  DROP  CATALOG  Example
    Example 1: Deleting a catalog

    The following statement deletes the catalog DEPT1 associated with
    the alias PERSONNEL_ALIAS:

    SQL> ATTACH 'ALIAS PERSONNEL_ALIAS FILENAME CORPORATE_DATA';
    SQL> SET QUOTING RULES 'SQL99';
    SQL> CREATE CATALOG "PERSONNEL_ALIAS.DEPT1";
    SQL> SHOW CATALOG;
    Catalogs in database PERSONNEL_ALIAS
        "PERSONNEL_ALIAS.ADMINISTRATION"
        "PERSONNEL_ALIAS.RDB$CATALOG""
        "PERSONNEL_ALIAS.DEPT1"
    SQL> DROP CATALOG "PERSONNEL_ALIAS.DEPT1";
    SQL> SHOW CATALOG;
    Catalogs in database PERSONNEL_ALIAS
        "PERSONNEL_ALIAS.ADMINISTRATION"
        "PERSONNEL_ALIAS.RDB$CATALOG"
    SQL> DROP CATALOG "PERSONNEL_ALIAS.RDB$CATALOG";
    %SQL-F-NODROPSYSCAT, Catalog "PERSONNEL_ALIAS.RDB$CATALOG" may not be
    dropped
    SQL>
Close Help