How to find which views are using a certain table in SQL Server 2008

Question

I have to add a few columns to a table and I also need to add these columns to all the views that use this table   Is it possible to get a list of all the views in a database that use a certain table

User · Answer

select your table -  view dependencies -  Objects that depend on

User · Answer

I find this works better   SELECT type    FROM sys objects WHERE OBJECT DEFINITION object id  LIKE        ObjectName       AND type IN   V   ORDER BY name   Filtering VIEW DEFINTION inside INFORMATION SCHEMA VIEWS is giving me quite a few false positives

User · Answer

Simplest way to find used view or stored procedure for the tableName using below query -  exec dbo dbsearch  Your Table Name

User · Answer

To find table dependencies you can use the sys sql expression dependencies catalog view   SELECT  referencing object name   o name   referencing object type desc   o type desc   referenced object name   referenced entity name   referenced object type desc  so1 type desc  FROM sys sql expression dependencies sed  INNER JOIN sys views o ON sed referencing id   o object id  LEFT OUTER JOIN sys views so1 ON sed referenced id  so1 object id  WHERE referenced entity name    Person      You can also try out ApexSQL Search a free SSMS and VS add-in that also has the View Dependencies feature  The View Dependencies feature has the ability to visualize all SQL database objects    relationships  including those between encrypted and system objects  SQL server 2012 specific objects  and objects stored in databases encrypted with Transparent Data Encryption  TDE   Disclaimer  I work for ApexSQL as a Support Engineer

User · Answer

SELECT VIEW NAME FROM INFORMATION SCHEMA VIEW TABLE USAGE WHERE TABLE NAME    Your Table

User · Answer

If you need to find database objects  e g  tables  columns  triggers  by name - have a look at the FREE Red-Gate tool called SQL Search which does this - it searches your entire database for any kind of string s        It s a great must-have tool for any DBA or database developer - did I already mention it s absolutely FREE to use for any kind of use

User · Answer

This should do it   SELECT    FROM   INFORMATION SCHEMA VIEWS  WHERE  VIEW DEFINITION like   YourTableName

[sql] How to find which views are using a certain table in SQL Server (2008)?

Examples related to sql

Examples related to sql-server

Examples related to views