CREATE SCHEMA

CREATE SCHEMA creates a new schema.

Syntax

CREATE SCHEMA [IF NOT EXISTS] <schema_name>;

Syntax element	Description
`IF NOT EXISTS`	If specified, do not generate an error if a schema of the same name already exists. If not specified, throw an error if a schema of the same name already exists.
`<schema_name>`	A name for the schema. You can specify the database for the schema with a preceding `database_name.schema_name`, e.g. `my_db.my_schema`, otherwise the schema is created in the current database.

By default, each database has a schema called public.

For more information, see Namespaces.

CREATE SCHEMA my_db.my_schema;

SHOW SCHEMAS FROM my_db;

public
my_schema

The privileges required to execute this statement are: