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.
Set the current schema to CORPDATA
SET SCHEMA CORPDATA
For more information, see SET SCHEMA in the SQL Reference topic in the
Information Center.