SQL in a Nutshell, 2nd Edition

Name

CREATE SCHEMA Statement

Synopsis

This statement creates a schema—i.e., a named group of related objects. A schema is a collection of tables, views, and permissions granted to specific users or roles. According to the ANSI standard, specific object permissions are not schema objects in themselves and do not belong to a specific schema. However, roles are sets of privileges that do belong to a schema.

Platform	Command
DB2	Supported, with limitations
MySQL	Not supported
Oracle	Supported, with variations
PostgreSQL	Not supported
SQL Server	Supported, with limitations

SQL2003 Syntax

CREATE SCHEMA [schema_name] [AUTHORIZATION owner_name]
[DEFAULT CHARACTER SET char_set_name]
[PATH schema_name [,...] ]
   [ ANSI CREATE statements [...] ]
   [ ANSI GRANT statements [...]  ]

Keywords

CREATE SCHEMA [schema_name]

Creates a schema called schema_name. When omitted, the database will create a schema name for you using the name of the user who owns the schema.

AUTHORIZATION owner_name

Sets the owner_name as the user who owns the schema. When omitted, the current user is set as the owner. The ANSI standard allows you to omit either the schema_name or the AUTHORIZATION clause, or to use them both together.

DEFAULT CHARACTER SET char_set_name

Declares a default character set of char_set_name for all objects created within the schema.

PATH schema_name [,...]

Optionally declares a file path and filename for any unqualified routines (i.e., stored procedures, user-defined functions, user-defined methods) ...