CREATE SCHEMA¶

CREATE SCHEMA schema-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 CREATE SCHEMA statement is subject to access control when the gemfirexd.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.

Example¶

• Create schema

CREATE SCHEMA myschema;

• 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;

CREATE SCHEMA reports AUTHORIZATION ldapgroup:finance;