CREATE SCHEMA

Synopsis

CREATE SCHEMA schema_name
[ WITH ( property_name = expression [, ...] ) ]

Description

Create a new, empty schema. A schema is a container that holds tables, views and other database objects.

The optional WITH clause can be used for Polars schema creation properties. The verified Polars schema type selector is typename = 'SimpleSchema'. If typename is omitted, Polars uses the default Polars schema type for the active table space.

Duplicate schema creation is not suppressed by IF NOT EXISTS in Polars SQL.

Examples

Create a new schema web in the current table space:

CREATE SCHEMA web

Create a new schema with an explicit Polars schema type:

CREATE SCHEMA web WITH (typename = 'SimpleSchema')

See Also

DROP SCHEMA