CREATE SCHEMA

Synopsis

CREATE {SCHEMA|DATABASE} [ IF NOT EXISTS ] schema_name
[ WITH ( property_name = expression [, ...] ) ]

Description

Create a new, empty schema. A schema is a container that holds tables, views and other database objects.

The optional IF NOT EXISTS clause causes the error to be suppressed if the schema already exists.

The optional WITH clause can be used to set properties on the newly created schema. To list all available schema properties, run the following query:

SELECT * FROM system.metadata.schema_properties

Examples

Create a new schema web in the current catalog:

CREATE SCHEMA web
CREATE DATABASE web

Create a new schema sales in the hive catalog:

CREATE SCHEMA hive.sales

Create the schema traffic if it does not already exist:

CREATE SCHEMA IF NOT EXISTS traffic

See Also

ALTER SCHEMA, DROP SCHEMA