INFORMATION_SCHEMA.VIEW_TABLE_USAGE is inaccurate?

by thundercougarfalcon   Last Updated November 14, 2017 17:06 PM

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



Related Questions





Patching SSRS on Always on Availability Groups

Updated September 22, 2017 21:06 PM