0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.