CREATE SCHEMA

Syntax

CREATE SCHEMA schema_name [IN DATABASE database_name];

Description

A Schema is a logical grouping of relational objects such as Streams, Changelogs and Materialized Views. Schemas are grouped in a Database. A combination of databases and schemas enable users to organize their streams, Changelogs, and other Database objects in a hierarchical fashion in DeltaStream. Such hierarchies also are one of the bases for providing Role-based Access Control (RBAC) in DeltaStream the same way as other relational databases. CREATE SCHEMA enters a new Schema into the current Database. The Schema name must be distinct from the name of any existing Schema in the current Database.

Arguments

schema_name

Name of the Schema to create. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

IN DATABASE database_name

Optionally, the Database the Schema should be created in. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Examples

Create a new Schema in default Database

The following creates a new Schema named newschema in the current Database demodb.

demodb.public/demostore# CREATE SCHEMA newschema;
demodb.public/demostore# LIST SCHEMAS;

     Name    | Default |  Owner   |      Created at      |      Updated at
-------------+---------+----------+----------------------+-----------------------
  public     | ✓       | sysadmin | 2022-08-22T17:01:02Z | 2022-08-22T17:01:02Z
  newschema  |         | sysadmin | 2022-08-22T17:01:02Z | 2022-08-22T17:01:02Z

Create a new Schema in a specified Database

The following creates a new Schema named NewSchema in the specified Database OtherDB.

demodb.public/demostore# CREATE SCHEMA "NewSchema" IN DATABASE "OtherDB";
demodb.public/demostore# LIST SCHEMAS IN DATABASE "OtherDB";

     Name    | Default |  Owner   |      Created at      |      Updated at
-------------+---------+----------+----------------------+-----------------------
  public     | ✓       | sysadmin | 2022-08-22T17:01:02Z | 2022-08-22T17:01:02Z
  NewSchema  |         | sysadmin | 2022-08-22T17:01:02Z | 2022-08-22T17:01:02Z