CREATE SCHEMA

The CREATE SCHEMA statement allows a user to create a schema.

Usage

CREATE SCHEMA
schema-name [DEFAULT CHARACTER SET character-set] |
AUTHORIZATION user-name |
schema-name AUTHORIZATION user-name
[SET SLABS TO ALL | slab-list]

Notes

This lets a user create a schema for someone else, providing they have the INSERT privilege on IPE_SCHEMA. The user creating a schema must have the CREATE SCHEMA privilege. (Typically, creating a schema is done by SYS when new users are created.)

See “Example: Creating and Dropping Schemas” on page 14 for an example of CREATE SCHEMA use.

See chapter 8 for details of supported character sets.

See the Kognitio Guide for details of disk store slabs.