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
-----------------------------------------------------------------------