INFORMATION_SCHEMA.VIEW_TABLE_USAGE is inaccurate?

Ask Question

Asked 3 years, 3 months ago

Active 3 years, 3 months ago

Viewed 187 times

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!

Erik Darling

30.9k13 gold badges101 silver badges184 bronze badges

asked Nov 14 '17 at 16:20

5301 gold badge3 silver badges16 bronze badges

Further Aaron Bertrand. – Erik Darling Nov 14 '17 at 16:24
Thanks! Bertrand is the Man! This was a frightful line from that article - msdn.microsoft.com/en-us/library/ms186224.aspx says: "Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view." The warning really should state that the INFORMATION_SCHEMA views are incomplete... – thundercougarfalcon Nov 14 '17 at 16:31

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

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