SQL SERVER 中查找无相关性的表、查找触发器的SQL语句

SQL SERVER 中查找无相关性的表、查找触发器的SQL语句

今天在清理公司的数据库服务器，写了几段sql脚本，觉得很有用，呵呵，就贴出来吧。。。

-------------------------------- 查找没有依赖关系的表----------------------

select name,crdate from sysobjects c where  type= 'u' and c.id not in

(

select distinct(b.id) from sysdepends b

)

and c.id not in

(

select distinct(d.depid) from sysdepends d

)

order by c.crdate desc

-------------------------------------------------------------------------

 

------------------- 查找没有依赖关系也没有触发器的表---------------------------

select name,crdate,id from sysobjects c where  type= 'u'

and c.id not in

(

select distinct(b.id) from sysdepends b

)

and c.id not in

(

select distinct(d.depid) from sysdepends d

)

and c.id not in

(

select parent_obj from sysobjects c where type= 'tr' and  xtype ='tr'

)

order by c.crdate desc

-----------------------------------------------------------------------

------------------------查找所有触发器-----------------------------------

select c.name as 触发器,a.name 相关的表

    from sysobjects c ,sysobjects a

    where c.type= 'tr' and  c.xtype ='tr'

    and c.parent_obj = a.id

-----------------------------------------------------------------------

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/sxf_zero/archive/2006/05/30/763290.aspx