Set or change the default schema for a connection's session.
SET SCHEMA schema-name
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.
-- below are equivalent assuming a TRADE schema SET SCHEMA TRADE; SET SCHEMA trade;