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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-66

CREATE SCHEMA Statement

For more examples, see the SQL/MX Guide to Stored Procedures in Java.

CREATE SCHEMA Statement

Considerations for CREATE SCHEMA

Examples of CREATE SCHEMA

CREATE SCHEMA creates an SQL/MX schema. See Schemas on page 6-101.

CREATE SCHEMA with the optional location clause is an SQL/MX extension.

Syntax Description of CREATE SCHEMA

schema

is a schema name for the new schema. A simple schema name is an SQL

identifier. A schema name can also be of the form

catalog-name.schema-name.

AUTHORIZATION auth-id

specifies the owner of the schema. The default is the current authorization ID. The

auth-id must be the current authorization ID unless the current authorization ID

is a SUPER user. A SUPER user can specify any currently valid authorization ID

as the owner of the schema.

CREATE SCHEMA schema-clause [schema-element

[, schema-element] ...]]

schema-clause is:

schema

| schema AUTHORIZATION auth-id

| schema AUTHORIZATION auth-id location-clause

| schema location-clause

location-clause is:

LOCATION subvolume [reuse-clause]

reuse-clause is:

REPEAT USE ALLOWED

schema-element is:

table-definition

| view-definition

| grant-statement

| index-definition