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::=

Open schema statement

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

Example

OPEN SCHEMA my_schema;