OPEN SCHEMA

Purpose

You can use this statement to open a schema that affects the name resolution.

Prerequisite

None

Syntax

open_schema::=

Open schema statement

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).

Example

OPEN SCHEMA my_schema;