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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.