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.

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