Example 1: Creating a schema within a multischema database

    The following interactive statements create a database that
    contains a schema within a catalog. You issue the CREATE SCHEMA
    statement alone or as part of a CREATE DATABASE statement.

    SQL> SET DIALECT 'SQL99';
    SQL> CREATE DATABASE ALIAS PERS_ALIAS FILENAME personnel MULTISCHEMA IS ON;
    SQL> CREATE CATALOG "PERS_ALIAS.ADMIN";
    SQL> CREATE SCHEMA "PERS_ALIAS.ADMIN".PAYROLL;
    SQL> SHOW SCHEMAS;
    Schemas in database PERS_ALIAS
        "PERS_ALIAS.ADMIN".PAYROLL
        "PERS_ALIAS.RDB$CATALOG".RDB$SCHEMA