SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-68
Considerations for CREATE SCHEMA
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.
Considerations for CREATE SCHEMA
Duplicate Schema Subvolume
One use of the schema subvolume is to identify all Guardian files in a schema for use
with Guardian-based commands for TMF, RDF or other subsystems. Unless you use
the REPEAT USE ALLOWED clause, NonStop SQL/MX prevents you from specifying
a subvolume name that is already in use by another schema. If you use this clause you
will receive a warning and the operation succeeds. This action is recommended only
when creating an RDF backup database.
If you do reuse a schema subvolume, a Guardian wild card of the form
\system.$*.subvolume.* will specify physical files from all schemas using this
subvolume name. This might affect your future ability to refer only to objects in specific
schemas when issuing commands to TMF or RDF.
Reserved Schema Names
Schema names that begin with DEFINITION_SCHEMA_VERSION_ are reserved (in
all catalogs) for system metadata. You cannot create schemas with these names in
user catalogs.
These names are not reserved (you can create schemas with these names in user
catalogs): SYSTEM_SCHEMA, SYSTEM_DEFAULTS_SCHEMA, MXCS_SCHEMA.