CREATE SCHEMA

The CREATE SCHEMA statement creates a new schema in a database catalog.

Syntax

CREATE SCHEMA [IF NOT EXISTS] [catalog_name.]schema_name

Parameters

• IF NOT EXISTS: Prevents an error from being raised if a schema with the same name already exists.
• catalog_name: Optional name of the catalog in which to create the schema.
• schema_name: The name of the schema to create.

Examples

Basic Schema Creation

Create a schema in the current catalog:

CREATE SCHEMA my_schema;

Create Schema in Specific Catalog

Create a schema in a specified catalog:

CREATE SCHEMA temp.my_schema;

Create Schema If Not Exists

Create a schema only if it doesn't already exist:

CREATE SCHEMA IF NOT EXISTS temp.my_schema;

This command won't raise an error if the schema already exists.