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!