Skip to main content
Schemas are logical containers for all database objects (tables, views, etc.). In order to place an object in a schema, the schema must be created first—schemas will not be automatically created when specified in CREATE TABLE or similar calls.
CREATE SCHEMA Syntax

​
Parameters

IF NOT EXISTS

Optional error suppression clause, which causes no error to be returned if a schema with the same name already exists

<schema name>

Name of the schema to create; must adhere to the supported naming criteria

​
Examples

CREATE SCHEMA Example