OPEN SCHEMA
Purpose
Use this statement to open a schema that affects the name resolution.
Prerequisite
You need either the system privilege USE ANY SCHEMA or the object privilege USAGE on the target schema, or the schema must be owned by you or one of your assigned roles.
Syntax
open_schema::=
Usage Notes
- You can identify the currently opened schema with the CURRENT_SCHEMA statement.
- You can close the schema with the CLOSE SCHEMA statement.
- If there is no schema opened, all schema objects must be referenced using schema-qualified names (for details, see SQL identifier).