# Find Tables that are in a View

- URL: https://dynamicaccounting.net/find-tables-that-are-in-a-view/
- Date: 2008-12-03
- Topics: SQL & Data
- Type: link to an external article
- Source: https://www.mssqltips.com/sqlservertip/1638/using-sql-server-meta-data-to-list-tables-that-make-up-views/

[MSSQLTips](https://www.mssqltips.com/sqlservertip/1638/using-sql-server-meta-data-to-list-tables-that-make-up-views/) 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](https://www.mssqltips.com/sqlservertip/1638/using-sql-server-meta-data-to-list-tables-that-make-up-views/)