Description

schema-name
Names the schema. A schema is created using this name. If schema-name is specified, the authorization ID of the statement is the run-time authorization ID. The name must not be the same as the name of an existing schema at the current server.
authorization-name
Identifies the authorization ID of the statement. This authorization name is also the schema-name. The name must not be the same as the name of an existing schema at the current server.
IN ASP integer
Specifies the auxiliary storage pool (ASP) in which to create the schema. The integer must be between 1 and 32. If 1 is specified, the schema is created on the system ASP. If this clause is omitted, an ASP of 1 is assumed.
IN ASP ASP-name
Specifies the auxiliary storage pool (ASP) in which to create the schema. The name must identify an auxiliary stroage pool that exists at the current server.
COMMENT statement
Adds or replaces comments in the catalog descriptions of tables, views, sequences, or columns. Comments on packages are not allowed. See the COMMENT statement COMMENT.
CREATE ALIAS statement
Creates an alias into the schema. See the CREATE ALIAS statement CREATE ALIAS.
CREATE DISTINCT TYPE statement
Creates a user-defined distinct type into the schema. See the CREATE DISTINCT TYPE statement CREATE DISTINCT TYPE.
CREATE INDEX statement
Creates an index into the schema. See the CREATE INDEX statement CREATE INDEX.
CREATE SEQUENCE statement
Creates a sequence into the schema. See the CREATE SEQUENCE statement CREATE SEQUENCE.
CREATE TABLE statement
Creates a table into the schema. See the CREATE TABLE statement CREATE TABLE.
CREATE VIEW statement
Creates a view into the schema. See the CREATE VIEW statement CREATE VIEW.
GRANT (Distinct Type Privileges) statement
Grants privileges for distinct types in the schema. See the GRANT statement GRANT (Distinct Type Privileges).
GRANT (Sequence Privileges) statement
Grants privileges for sequences in the schema. See the GRANT statement GRANT (Sequence Privileges).
GRANT (Table Privileges) statement
Grants privileges for tables and views in the schema. See the GRANT statement GRANT (Table or View Privileges).
LABEL statement
Adds or replaces labels in the catalog descriptions of tables, views, sequences, or columns in the schema. Labels on packages are not allowed. See the LABEL statementLABEL.