Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage

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