SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-90
Examples of CREATE SCHEMA
Authorization and Availability Requirements
A catalog owner and the users who are granted the privilege by using GRANT
CREATE SCHEMA can create a schema. If such users are not specified, any user can
execute this statement.
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;