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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
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;