关闭

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

2249人阅读 评论(0) 收藏 举报

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

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

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:86807次
    • 积分:1134
    • 等级:
    • 排名:千里之外
    • 原创:24篇
    • 转载:8篇
    • 译文:0篇
    • 评论:16条
    链接