SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-69
Syntax Description of CREATE SCHEMA
RDF backup database. In this case, the subvolume name for each backup schema
should match the subvolume name for the corresponding schema in the primary
database.
In either case, the schema subvolume is written to the
SCHEMATA.SCHEMA_SUBVOLUME column in the SQL/MX system schema. The
schema subvolume is used as the subvolume for the locations of all objects
created within that schema.
If the optional subvolume name is omitted, NonStop SQL/MX generates a
subvolume name for the schema.
Follow these guidelines when using SQL/MX subvolume names:
•
The name must begin with the letters ZSD, followed by a letter, not a digit (for
example, ZSDa, not ZSD2).
•
The name must be exactly eight characters long.
•
All Guardian files representing data in a particular schema must have the same
subvolume name regardless of the volume on which they reside. This
subvolume name must match the subvolume name indicated in the system
schema column SCHEMATA.SCHEMA_SUBVOLUME.
Valid SQL/MX subvolume names are:
ZSDBMM3K
ZSDADMM8
schema-element
specifies the objects to be defined in the schema being created. The element in the
statement must be in the same schema as the schema you are creating. Schema
elements must appear in sequence—a schema element that depends on another
schema element must be listed after that schema element.
table-definition
is a CREATE TABLE statement.
view-definition
is a CREATE VIEW statement.
grant-statement
is a GRANT statement.
index-definition
is a CREATE INDEX statement. index-definition cannot be the only
schema-element.