CREATE SCHEMA
Attention
This page documents an earlier version. Go to the latest (v2.3) version.Synopsis
Use the CREATE SCHEMA
statement to enter a new schema into the current database.
Syntax
create_schema ::= CREATE SCHEMA [ IF NOT EXISTS ] schema_name
[ schema_element [ ... ] ]
create_schema
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.