Creates a new schema in the current default catalog of a
    multischema database.

                                   NOTE

       Use of the CREATE SCHEMA statement to create a database is
       a deprecated feature. If you specify physical attributes of
       a database such as the root file parameters, you receive an
       informational message, but SQL creates the database anyway.

       SQL> CREATE SCHEMA FILENAME TEST SNAPSHOT IS DISABLED;
       %SQL-I-DEPR_FEATURE, Deprecated Feature: SCHEMA (meaning DATABASE)

       If you do not specify any physical attributes, you may
       receive an error message noting that you must enable
       multischema naming.

       SQL> CREATE SCHEMA PARTS
       %SQL-F-SCHCATMULTI, Schemas and catalogs may only be referenced with
       multischema enabled

    A schema is a group of definitions within a database. The CREATE
    SCHEMA statement lets you specify in a single SQL statement all
    data and privilege definitions for a new schema. You can also add
    definitions to the schema later.

    A database, in addition to schema definitions, includes database
    system files and user data. If you need to specify any physical
    database characteristics such as the database root file or
    storage area parameters, use the CREATE DATABASE statement. See
    the CREATE DATABASE statement for more information.

    You can specify any number of optional schema elements to the
    CREATE SCHEMA statement. Schema elements are any of the CREATE
    statements (except CREATE STORAGE AREA, CREATE DOMAIN . . . FROM
    path-name, and CREATE TABLE . . . FROM path-name) or a GRANT
    statement.

    These statements require statement terminators, except when they
    are part of a CREATE SCHEMA or CREATE DATABASE statement. When
    you use these statements within a CREATE SCHEMA statement, use a
    statement terminator on the last schema element only. The first
    statement terminator that SQL encounters ends the CREATE SCHEMA
    statement. Later CREATE or GRANT statements are not within the
    scope of the CREATE SCHEMA statement.