CREATE SCHEMA

Create a schema in the default database.

Syntax

CREATE SCHEMA [IF NOT EXISTS] <schema-name>;

Field	Description
schema-name	Name of the schema.

Specifying IF NOT EXISTS will suppress an error if schema-name already exists.

Examples

Create a schema named my_schema if it doesn’t already exist.

CREATE SCHEMA IF NOT EXISTS my_schema;