# CREATE SCHEMA

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
CREATE SCHEMA schema_name [IN DATABASE database_name];
```

## Description <a href="#description" id="description"></a>

A [schema](https://docs.deltastream.io/overview/core-concepts/databases#_schema) is a logical grouping of relational objects such as [streams](https://docs.deltastream.io/overview/core-concepts/databases#_stream), [changelogs](https://docs.deltastream.io/overview/core-concepts/databases#_changelog) and [materialized views](https://docs.deltastream.io/overview/core-concepts/databases#_materialized_view). Schemas are grouped in a [database](https://docs.deltastream.io/overview/core-concepts/databases). A combination of databases and schemas enable you to organize your streams, changelogs, and other database objects in a hierarchical fashion in DeltaStream. Such hierarchies also serve as a basis for providing role-based access control (RBAC) in DeltaStream in 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. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

#### IN DATABASE database\_name

Optionally, the database i which to create the schema. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

## Examples

#### Create a new schema in default database

The following creates a new schema named `newschema` in the current database `demodb`:

```sh
demodb.public/<no-store># CREATE SCHEMA newschema;
+------------+----------------+------------+------------------------------------------+
|  Type      |  Name          |  Command   |  Summary                                 |
+============+================+============+==========================================+
| schema     | mydb.newschema | CREATE     | schema "demodb.newschema" was            |
|            |                |            | successfully created                     |
+------------+----------------+------------+------------------------------------------+
demodb.public/<no-store># LIST SCHEMAS;
+------------+-------------+------------+-------------------------------+
|  Name      |  Is Default |  Owner     |  Created At                   |
+============+=============+============+===============================+
| public     | true        | sysadmin   | 2023-08-09 17:14:46 +0000 UTC |
+------------+-------------+------------+-------------------------------+
| newschema  | false       | sysadmin   | 2024-07-02 21:20:23 +0000 UTC |
+------------+-------------+------------+-------------------------------+
```

#### Create a new schema in a specified database

The following creates a new schema named `NewSchema` in the specified database `otherdb`:

```sh
demodb.public/<no-store># CREATE SCHEMA "NewSchema" IN DATABASE otherdb;
+------------+-------------------+------------+------------------------------------------+
|  Type      |  Name             |  Command   |  Summary                                 |
+============+===================+============+==========================================+
| schema     | otherdb.NewSchema | CREATE     | schema "otherdb.NewSchema" was           |
|            |                   |            | successfully created                     |
+------------+-------------------+------------+------------------------------------------+
demodb.public/<no-store># LIST SCHEMAS IN DATABASE otherdb;
+------------+-------------+------------+-------------------------------+
|  Name      |  Is Default |  Owner     |  Created At                   |
+============+=============+============+===============================+
| public     | true        | sysadmin   | 2024-07-02 21:21:18 +0000 UTC |
+------------+-------------+------------+-------------------------------+
| NewSchema  | false       | sysadmin   | 2024-07-02 21:21:25 +0000 UTC |
+------------+-------------+------------+-------------------------------+
```