摘要： http://www.mssqltips.com/sql_server_developer_tips.asp 阅读全文

摘要： select * from (select refName = object_name(referenced_object_id), parentObject = object_name(parent_object_id) , objectName= object_name(object_id) from sys.foreign_keys ) m 阅读全文

摘要： select distinct OBJECT_NAME(deps.depid),obj.type,'referenced by object' = obj.name from sys.objects obj, sysdepends deps where obj.object_id = deps.id 阅读全文