CREATE SCHEMA

Creates a new schema in the current database. Schemas are logical namespaces that organize tables, views, and other database objects. Every database includes a default schema named public. You can create additional schemas to separate and organize objects by function, team, or access level.

Syntax

CREATE SCHEMA [IF NOT EXISTS] <schema_name>

Parameters

Parameter	Description
`IF NOT EXISTS`	Prevents an error if a schema with the same name already exists. Without this clause, the statement fails if the schema already exists.
`<schema_name>`	The name of the schema to create. Must be unique within the database.

All identifiers are case-insensitive unless enclosed in double-quotes. For more information, see Object identifiers.

Examples

Create a schema

CREATE SCHEMA analytics;

Create a schema only if it does not already exist

CREATE SCHEMA IF NOT EXISTS staging;

Create objects within a schema After creating a schema, you can create tables, views, and other objects inside it by qualifying the object name with the schema:

CREATE SCHEMA IF NOT EXISTS analytics;

CREATE TABLE analytics.events (
    event_id INTEGER,
    event_type TEXT,
    event_date DATE
);

CREATE VIEW analytics.recent_events AS
SELECT * FROM analytics.events WHERE event_date > '2025-01-01';

Reference objects using two-part and three-part identifiers You can reference objects using a two-part identifier (schema.object) when the database context is already set, or a three-part identifier (database.schema.object) to fully qualify the object across databases:

USE DATABASE my_db;

SELECT * FROM analytics.events;

SELECT * FROM my_db.analytics.events;

DROP SCHEMA - Delete a schema
ALTER SCHEMA - Modify schema properties

CREATE LOCATION

CREATE STREAM

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Examples

​Syntax

​Parameters

​Examples

​Related commands

Syntax

Parameters

Examples

Related commands