SET SCHEMA

The SET SCHEMA statement changes the value of the CURRENT SCHEMA special register.  You can set the schema equal to a specific schema name, the value in the USER special register, the default schema, or to a string constant.

Example:

Set the current schema to CORPDATA

SET SCHEMA CORPDATA

For more information, see SET SCHEMA in the SQL Reference topic in the Information CenterLink to Information center.