Is it possible to find out dependent tables for a

Question

Apparently, one of my views is not responding to any SQL queries. I was wondering if there is a way to find out what tables this view depends on so that I can debug the problem.

I am not an admin on the server so I wouldn't be surprised if this is not possible in the first place but a confirmation would be great. Any suggestions?

Answer 1

You should get an error message like the one below, if you try the query from Management Studio

Msg 208, Level 16, State 1, Line 1
Invalid object name 'table_missing'.
Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'view_name' because of binding errors.

Answer 2

Although not infallible, you could start with sp_depends

Answer 3

You just look at the definition of the view

One way (fixed)

SELECT OBJECT_DEFINITION(OBJECT_ID(N'myview'))

This is subject to "metadata visibility" of course and permissions