SQL Server queries a table for dependent views, stored procedures, functions

Sp_depends ' table name ' But this is a good way to save all the SQL statements from being exported and looking for. However, as a reminder, if you use this table in dynamic SQL in a stored procedure, you are not expected to find it. SELECT name, definition
From Sys.all_objects o
Inner join sys.sql_modules m on m.object_id = o.object_id
WHERE (o.[type]= ' P ' or o.[type]= ' X ' or o.[type]= ' PC ')
and o.[is_ms_shipped]=0
and definition like '%t_forminstance_global% '
Order BY name
This method can be used to find the table dependencies in dynamic SQL, where "T_forminstance_global" is the table name.
But the type of sys.all_objects needs to be given to the specific reference: http://technet.microsoft.com/zh-cn/LIBRARY/ms178618

SQL Server queries a table for dependent views, stored procedures, functions