1

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

2

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.