CREATE DATABASE statement (cont’d)
WORKLOAD COLLECTION clause, 6–371
CREATE DOMAIN statement, 6–385
COLLATING SEQUENCE clause, 6–389,
6–395
COMMENT IS clause, 6–389
domain constraint clause, 6–390
FROM path-name clause, 6–391
in CREATE SCHEMA statement, 6–504
NO COLLATING SEQUENCE clause, 6–392
of CREATE DATABASE statement, 6–338
STORED NAME IS clause, 6–392
use of National Character Set (NCS) utility,
6–389
CREATE FUNCTION statement, 6–398, 6–482
in CREATE SCHEMA statement, 6–504
of CREATE DATABASE statement, 6–338
CREATE INDEX statement, 6–399
DISABLE COMPRESSION clause, 6–403
ENABLE COMPRESSION clause, 6–404
in CREATE SCHEMA statement, 6–504
MAINTENANCE clause, 6–405
of CREATE DATABASE statement, 6–338
PREFIX CARDINALITY COLLECTION IS
DISABLED clause, 6–408
PREFIX CARDINALITY COLLECTION IS
ENABLED clause, 6–408
PREFIX CARDINALITY COLLECTION IS
ENABLED FULL clause, 6–408
restriction, 6–417
STORED NAME IS clause, 6–409
TYPE IS HASHED ORDERED clause, 6–410
TYPE IS HASHED SCATTERED clause,
6–410
TYPE IS SORTED clause, 6–412
TYPE IS SORTED RANKED clause, 6–413
CREATE MODULE statement, 6–425
in CREATE SCHEMA statement, 6–504
of CREATE DATABASE statement, 6–338
CREATE OUTLINE statement, 6–450
CREATE PROCEDURE statement, 6–473,
6–482
in CREATE SCHEMA statement, 6–504
of CREATE DATABASE statement, 6–338
Create Routine statement
See CREATE FUNCTION statement
See CREATE PROCEDURE statement
CREATE ROUTINE statement
in CREATE SCHEMA statement, 6–504
of CREATE DATABASE statement, 6–338
CREATE SCHEMA statement, 6–502
See also CREATE DATABASE statement
AUTHORIZATION clause, 6–504
authorization identifier, 6–504
CREATE COLLATING SEQUENCE
statement, 6–504
CREATE DOMAIN statement, 6–504
CREATE FUNCTION statement, 6–504
CREATE INDEX statement, 6–504
CREATE MODULE statement, 6–504
CREATE PROCEDURE statement, 6–504
CREATE SEQUENCE statement, 6–504
CREATE STORAGE MAP statement, 6–505
CREATE TABLE statement, 6–505
CREATE TRIGGER statement, 6–505
CREATE VIEW statement, 6–505
environment, 6–503
GRANT statement, 6–505
in dynamic SQL, 6–503
in embedded SQL, 6–503
in interactive SQL, 6–503
of CREATE DATABASE statement, 6–339
schema name clause, 6–505
CREATE SEQUENCE statement
in CREATE SCHEMA statement, 6–504
CREATE statement
general usage notes, 6–301
CREATE STORAGE AREA clause
of CREATE DATABASE statement, 6–339
CREATE STORAGE MAP statement
in CREATE SCHEMA statement, 6–505
of CREATE DATABASE statement, 6–339
CREATE TABLE statement
in CREATE SCHEMA statement, 6–505
of CREATE DATABASE statement, 6–339
specifying domains for data types, 6–385
CREATE TRIGGER statement
in CREATE SCHEMA statement, 6–505
of CREATE DATABASE statement, 6–339
Index–12