Specifies the default schema name for the module. The default
    schema is the schema to which SQL statements refer if those
    statements do not qualify table names and other schema names
    with an authorization identifier. If you do not specify a
    default schema name for a module, you must specify a default
    authorization identifier.

    Using the SCHEMA clause, separate modules can each declare
    different schemas as default schemas. This can be convenient for
    an application that needs to refer to more than one schema. By
    putting SQL statements that refer to a schema in the appropriate
    module's procedures, you can minimize tedious qualification of
    schema element names in those statements.

    When you specify SCHEMA schema-name AUTHORIZATION auth-id, you
    specify the schema name and the schema authorization identifier
    for the module. The schema authorization identifier is considered
    the owner and creator of the schema and everything in it.