CREATE SCHEMA statement

Description

Creates a schema, which is a collection of tables, views, and permissions and their associated permissions, for a database user.

Syntax

CREATE SCHEMA AUTHORIZATION userid
... [ { create-table-statement
| create-view-statement
| grant-statement } ] …

Usage

The userid must be the user ID of the current connection. You cannot create a schema for another user. The user ID is not case sensitive.

If any of the statements in the CREATE SCHEMA statement fail, the entire CREATE SCHEMA statement is rolled back.

CREATE SCHEMA statement is simply a way to collect individual CREATE and GRANT statements into one operation. There is no SCHEMA database object created in the database, and to drop the objects you must use individual DROP TABLE or DROP VIEW statements. To revoke permissions, use a REVOKE statement for each permission granted.

NoteThe CREATE SCHEMA statement is invalid on an active multiplex.

Individual CREATE or GRANT statements are not separated by statement delimiters. The statement delimiter marks the end of the CREATE SCHEMA statement itself.

The individual CREATE or GRANT statements must be ordered such that the objects are created before permissions are granted on them.

Although you can currently create more than one schema for a user, this is not recommended, and might not be supported in future releases.


Side effects

Automatic commit.

Standards

Permissions

Must have RESOURCE authority.

See also

CREATE TABLE statement

CREATE VIEW statement

GRANT statement