SET SCHEMA

Select a different schema

Arguments

<schemaName> (mandatory) a valid schema name

Examples

SET SCHEMA INFORMATION_SCHEMA;

Notes

Changes the current schema for the active connection: SET SCHEMA <schemaName>.

schemaName is mandatory and must be an existing schema of the current connection (matched case-insensitively); the command fails with an error if it is missing or unknown. Once set, unqualified table names in subsequent SQL statements resolve against this schema for the rest of the session (until changed again or the connection is closed).

Last modified in release 4.9.8.