SXF的专栏

Copyright COPY sxf

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

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

阅读更多
个人分类: 数据库
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

不良信息举报

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

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭