Find Tables that are in a View

MSSQLTips has a new article with code showing how to find all the tables that are used in a view. This could be very useful for breaking down that SSRS related view left for you by your predecessor. Also in the article is a script to show all the views that a particular table is used in. Helpful if you are wanting to remove a table or when trying to find all the places a table is used.

I’m posting this via email so if the link above doesn’t come through, the link is http://www.mssqltips.com/tip.asp?tip=1638