Use the CREATE SCHEMA
command to create a new schema.
Parameter or clause | Description |
---|---|
schema_name | The name of the schema to be created. |
IF NOT EXISTS clause | Creates a schema if the schema name has not already been used. Otherwise throws an error. |
database_name | The name of the database for the schema to be created in. If not specified, the schema will be created in the default database dev. |
AUTHORIZATION clause | Specifies the owner or authorized user of the schema. If the schema_name is omitted, the user_name is used as the schema name. |
user_name | Specifies the username of the owner or authorized user of the schema. |