tables

The set of tables & views referenced in a query.

Syntax

  TABLES

Returns

Returns a set of all tables & views that are referenced in the query. Tables/views 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 identifiers (quoted or unquoted). This is not a string.

Examples

TABLES CONTAINS "DB1"."S1"."T1"

TABLES CONTAINS ALL ("DB1"."S1"."T1", "DB2"."S2"."T2")

TABLES CONTAINS ANY ("DB1"."S1"."T1", "DB2"."S2"."T2")