Skip to main content

CREATE SCHEMA (SQL)

Creates a schema.

Synopsis

CREATE SCHEMA [ IF NOT EXISTS ] name

Arguments

Argument Description
name The name of the schema being created. The name is an identifier.
IF NOT EXISTS Optional — Suppresses the error that arises if a schema with name already exists. The schema is not re-created.

Description

Creates a schema definition, along with a corresponding package definition. The owner of the schema will be defined as the user who issues this command. A schema created in this manner will not appear in INFORMATION_SCHEMA.SCHEMATA until a table has been created within the schema.

If IF NOT EXISTS was specified and the schema already exists, this command performs no action. If IF NOT EXISTS was not specified but a schema with the same name already exists, SQLCODE -476 is returned.

See Also

FeedbackOpens in a new tab