Commands
CREATE SCHEMA
Use the CREATE SCHEMA
command to create a new schema.
Syntax
Parameters
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. |
Examples
NOTE
Names and unquoted identifiers are case-insensitive. Therefore, you must double-quote any of these fields for them to be case-sensitive. See also Identifiers.
Examples of AUTHORIZATION clause
Was this page helpful?