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. If SQL comprehension fails for portions of the query, the set will also include null.

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