Finding Dependent Tables

[lpbruce]

Hi - I'm sure there is a simple query for this. I need to create a query that will list all views and Stored Procs in a Database and all the tables and views that they are dependent on. I know there is a query where you can use the system tables, but I cannot find it. Any help would be greatly appreciated.

Thank you,

Lisa

 

[mrdenny]

Look at the sysdepends table.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com