CREATE SCHEMA

Creates a schema with the given name which provides a mechanism to logically group objects.

Syntax

CREATE SCHEMA schema-name [ DEFAULT SERVER GROUPS ( server_group_name [ , server_group_name ] * ) ]

Description

This creates a schema with the given name which provides a mechanism to logically group objects by providing a namespace for objects. This can then be used by other CREATE statements as the namespace prefix. For example, CREATE TABLE SCHEMA1.TABLE1 ( ... ) will create a table TABLE1 in the schema SCHEMA1. The DEFAULT SERVER GROUPS for a schema specifies the server groups used by the CREATE TABLE statement by default when no explicit server groups have been mentioned.

Note: Specifying the default server groups for a schema does not limit tables in that schema to be in those server groups, it just specifies the default server groups for tables in that schema.

The CREATE SCHEMA statement is subject to access control when the sqlfire.sql-authorization property is set to true for the system. Only the system user can create a schema with a name different from the current user name, and only the system user can specify AUTHORIZATION user-name with a user-name other than the current user name.

There is no single owner of the entire distributed system. Instead, ownership is defined by the distributed member joining the system. The distributed member process must boot up using theuser attribute in the properties to indicate owner of that process. A member that boots in this way can create a schema or grant access to a schema across the distributed system.

Example

CREATE SCHEMA myschema DEFAULT SERVER GROUPS (srvrgrp1,srvrgrp2);

–- create schema that uses the authorization id 'shared' as schema-name
CREATE SCHEMA AUTHORIZATION shared

-- create schema flights and authorize anita to all the objects that use the schema.
CREATE SCHEMA flights AUTHORIZATION anita