SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-71
Considerations for CREATE SCHEMA
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.
Schemas named SYSTEM_SCHEMA, SYSTEM_DEFAULTS_SCHEMA and
MXCS_SCHEMA in the system catalog are reserved for metadata. You cannot drop
them or create objects in them.
Examples of CREATE SCHEMA
•
This example creates a schema:
CREATE SCHEMA mycat.myschema;