SET SCHEMA
Contents
Syntax
SET SCHEMA <expr>
SET SCHEMA
changes the currently selected schema. The current schema is
where objects (such as tables, sequences, etc) are located or created.
The default schema is PUBLIC
and is created automatically when the database
file is initialized.
CURRENT_SCHEMA
can be used in expressions to get the currently selected
schema.
Examples
CREATE SCHEMA foo;
VALUES CURRENT_SCHEMA;
SET SCHEMA 'FOO';
VALUES CURRENT_SCHEMA;
-- msg: CREATE SCHEMA 1
-- COL1: PUBLIC
-- msg: SET SCHEMA 1
-- COL1: FOO