Resources

CREATE SCHEMA Statement

duckdb.org

The CREATE SCHEMA statement creates a schema in the catalog. The default schema is main. Examples Create a schema: CREATE SCHEMA s1; Create a schema if it does not exist yet: CREATE SCHEMA IF NOT EXISTS s2; Create table in the schemas: CREATE TABLE s1.t (id INTEGER PRIMARY KEY, other_id INTEGER); CREATE TABLE s2.t (id INTEGER PRIMARY KEY, j VARCHAR); Compute a join between tables from two schemas: SELECT * FROM s1.t…

Visit Site