Good morning All,
Trying to find dependencies on specific tables. Used
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE...
The above query appeared to confirm my assumption; however when I ran
SELECT *
FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE TABLE_NAME LIKE...
The results were inaccurate!
I checked the definition of some of INFORMATION_SCHEMA.VIEW_TABLE_USAGE
, and it doesn't reference the tables in question. Why is it wrong?!
Already checked out this post - Thanks Aaron Bertrand!
INFORMATION_SCHEMA.VIEW_TABLE_USAGE only shows tables from the same catalog