How to find which views are using a certain table in SQL Server (2008)? February 11, 2023 by Tarik This should do it: SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE VIEW_DEFINITION like '%YourTableName%'