SET SCHEMA

Set or change the default schema for a connection's session.

SET SCHEMA schema-name

Description

The SET SCHEMA statement sets or changes the default schema for a connection's session to the provided schema. This is then used as the schema for all statements issued from the connection that does not explicitly specify a schema name.
The default schema is APP.

Example

-- below are equivalent assuming a TRADE schema
SET SCHEMA TRADE;
SET SCHEMA trade;