CREATE SCHEMA

Synopsis

Use the CREATE SCHEMA statement to enter a new schema into the current database.

Syntax

• Grammar
• Diagram

create_schema ::= CREATE SCHEMA [ IF NOT EXISTS ] schema_name 
                  [ schema_element [ ... ] ]

Semantics

• AUTHORIZATION clause is not yet supported.

create_schema

CREATE SCHEMA [ IF NOT EXISTS ] schema_name [ schema_element [ … ] ]

Create a schema in the current database.

schema_name

Specify the name of the schema to be created. The schema name must be unique.

schema_element

Specify the SQL statement that defines a database object to be created within the schema. Acceptable clauses are CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE SEQUENCE, and GRANT. Other database objects must be created in separate commands after the schema is created.

See also

• CREATE TABLE
• CREATE VIEW
• CREATE INDEX
• CREATE SEQUENCE
• GRANT