CREATE SCHEMA Statement
statement_CREATE_SCHEMA ::= CREATE [ IF NOT EXISTS ] SCHEMA application_name
Description
The CREATE SCHEMA statement creates a new schema in the database (and also a new application from the developer interface view). If you wish to manipulate objects in a different schema, you must prefix objects with the desired schema name.
The maximum length of a schema name is 31 characters. Each schema must have a unique name in the database context. If the specified schema name already exists the error sqlstate 40004 (KEY_DUPLICITY) occurs.
See
