SQL Server 2005 search views for certain database objects -
Is there a list of all the ideas in the database that connects to a particular object in SQL Server?
i.e.: All ideas that link to myTable
You can use : Select
object_name (object_id), * sys.sql_dependencies from where referenced_major_id = object_id ('& lt; tablename & gt;');
This will list all the objects dependent on your table, you can restrict it by seeing it in the opposite:
select v. Joining D from Sys.sql_dependencies to d.object_id = v.object_id on sys.views v where referenced_major_id = object_id ('& lt; tablename & gt;');
Comments
Post a Comment