查询数据库所有依赖

存储过程，视图等涉及的所有表

SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name, 
    o.type_desc AS referencing_desciption, 
    COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id, 
    referencing_class_desc, referenced_class_desc,
    referenced_server_name, referenced_database_name, referenced_schema_name,
    referenced_entity_name, 
    COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name,
    is_caller_dependent, is_ambiguous
FROM sys.sql_expression_dependencies AS sed
INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id

exec  sp_helpconstraint 'Power_Controller';

SELECT OBJECT_SCHEMA_NAME(parent_object_id) AS SchemaName
, OBJECT_NAME(parent_object_id) AS TableName ,Name,OBJECT_NAME(object_id)
,object_name(referenced_object_id)
 FROM sys.foreign_keys  
WHERE referenced_object_id=OBJECT_ID('dbo.Power_Controller')


select t1.name,t2.rtableName,t2.name     
from     
(select col.name, f.constid as temp     
from syscolumns col,sysforeignkeys f     
where f.fkeyid=col.id     
and f.fkey=col.colid     
and f.constid in     
( select distinct(id)      
   from sysobjects     
   where OBJECT_NAME(parent_obj)='Power_Action'     
   and xtype='F'     
  )     
) as t1 ,     
(select OBJECT_NAME(f.rkeyid) as rtableName,col.name, f.constid as temp     
from syscolumns col,sysforeignkeys f   
where f.rkeyid=col.id     
and f.rkey=col.colid     
and f.constid in     
( select distinct(id)     
   from sysobjects     
   where OBJECT_NAME(parent_obj)='Power_Action'     
   and xtype='F'     
)     
) as t2     
where t1.temp=t2.temp