CREATE SCHEMA

The CREATE SCHEMA statement creates a schema in which tables, views, indexes, aliases, procedures, functions, triggers, and packages can be created.  You can also use the term COLLECTION instead of SCHEMA.

Example:

Create a schema called DBTEMP.

CREATE SCHEMA DBTEMP

For more information, see CREATE SCHEMA in the SQL Reference topic in the Information CenterLink to Information center.