OPEN SCHEMA
Purpose
You can use this statement to open a schema that affects the name resolution.
Prerequisite
None
Syntax
open_schema::=
Usage Notes
- You can identify the currently opened schema with CURRENT_SCHEMA statement.
- You can close the schema CLOSE SCHEMA statement.
- If there is no schema opened, all the schema objects must be referenced using schema-qualified names (for details, see SQL identifier).