SQL$HELP72.HLB  —  CREATE  SCHEMA  Arguments

1  –  AUTHORIZATION auth id

    If you do not specify a schema name, the authorization identifier
    specifies the default schema.

    If you want to comply with the ANSI/ISO 1989 standard, specify
    the AUTHORIZATION clause without the schema name. Specify both
    the AUTHORIZATION clause and the schema name to comply with the
    current ANSI/ISO SQL standard.

2  –  create-collating-sequence-statement

    See the CREATE COLLATING_SEQUENCE statement for details.

    If you want to specify a collating sequence in a CREATE DOMAIN
    statement embedded in a CREATE SCHEMA statement, you must first
    specify a CREATE COLLATING SEQUENCE statement within the same
    CREATE SCHEMA statement.

3  –  create-domain-statement

    See the CREATE DOMAIN statement for details.

    You cannot use the FROM path-name clause when embedding a CREATE
    DOMAIN statement in a CREATE SCHEMA statement. You can, however,
    issue a separate CREATE DOMAIN statement following the CREATE
    SCHEMA statement. You can also describe the domain directly
    within the CREATE SCHEMA statement.

    If you want to specify a collating sequence in your embedded
    CREATE DOMAIN statement, you must first specify a CREATE
    COLLATING SEQUENCE statement within the same CREATE SCHEMA
    statement.

4  –  create-function-statement

    See the CREATE Routine statement for details.

5  –  create-index-statement

    See the CREATE INDEX statement for details.

6  –  create-module-statement

    See the CREATE MODULE statement for details.

7  –  create-procedure-statement

    See the CREATE Routine statement for details.

8  –  create-sequence-statement

    See the CREATE SEQUENCE statement for details.

9  –  create-storage-map-statement

    See the CREATE STORAGE_MAP statement for details.

10  –  create-table-statement

    See the CREATE TABLE statement for details.

    You cannot use the FROM path-name clause when embedding a CREATE
    TABLE statement in a CREATE SCHEMA statement. You can, however,
    issue a separate CREATE TABLE statement following the CREATE
    SCHEMA statement. You can also describe the table directly within
    the CREATE SCHEMA statement.

    The CREATE TABLE statements in a CREATE SCHEMA statement can
    refer to domains not yet created, provided that CREATE DOMAIN
    statements for the domains are in the same CREATE SCHEMA
    statement.

11  –  create-trigger-statement

    See the CREATE TRIGGER statement for details.

12  –  create-view-statement

    See the CREATE VIEW statement for details.

13  –  grant-statement

    See the GRANT statement for details.

14  –  schema-element

    Some CREATE statements or a GRANT statement.

15  –  schema-name

    Specifies the name of the schema created by the CREATE SCHEMA
    statement.

    You can qualify the schema name with either a catalog name or the
    catalog name qualified by the alias. You must enclose the alias
    and catalog name in double quotation marks and separate them with
    a period. You must issue the SET QUOTING RULES statement before
    you specify the alias and catalog name pair, or SQL issues an
    error message about the use of double quotation marks.

    For information on qualifying schema names with aliases and
    catalog names, see the User_Supplied_Names HELP topic.
Close Help