Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage
  1. Docs
  2. /
  3. Reference
  4. /
  5. Hook Conditions
  6. /
  7. schemas

schemas

The set of schemas referenced in a query.

Syntax 

  SCHEMAS

Returns

Returns a set of all schemas that are referenced in the query. Schemas are fully-qualified even if the actual references are relatively qualified.

Usage Notes

  • Any values that are compared to must be fully-qualified in the condition.
  • The provided values should be a dot delimited identifier (quoted or unquoted). This is not a string.

Examples 

SCHEMAS CONTAINS "DB1"."S1"

SCHEMAS CONTAINS ALL ("DB1"."S1", "DB2"."S2")

SCHEMAS CONTAINS ANY ("DB1"."S1", "DB2"."S2")