SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-72
Examples of CREATE SCHEMA
•
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;