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
-
DROP SCHEMA