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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-69
Examples of CREATE 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;
•
This example creates a schema with pubs.jsmith as the owner, located on
subvolume ZSDABCDE:
CREATE SCHEMA sch2 AUTHORIZATION 'pubs.jsmith' LOCATION
ZSDABCDE;
•
This example creates a schema located on subvolume ZSDSCHEM:
CREATE SCHEMA myschema LOCATION ZSDSCHEM;
•
This example intentionally creates a schema located on subvolume ZSDSCHE2
when that subvolume is already in use by another schema:
CREATE SCHEMA myschema LOCATION ZSDSCHE2 REPEAT USE ALLOWED;