tables
The set of tables & views referenced in a query.
TABLES
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.
- 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.
TABLES CONTAINS "DB1"."S1"."T1"
TABLES CONTAINS ALL ("DB1"."S1"."T1", "DB2"."S2"."T2")
TABLES CONTAINS ANY ("DB1"."S1"."T1", "DB2"."S2"."T2")