관리 메뉴

why don't do your best

트리거찾기 본문

Database/MSSQL

트리거찾기

빅셔 2011. 7. 9. 20:10

select    (select F.name from sysusers F where N.uid=F.uid) as 테이블소유자
        ,N.name as 테이블명
        ,(select G.name from sysusers G where T.uid=G.uid) as 트리거소유자 
       ,T.triggername as 트리거명
        ,T.crdate as 생성일
from sysobjects N,
    (select name as triggername, parent_obj,crdate,uid from sysobjects where  xtype='TR') T
where N.id=T.parent_obj
order by  T.triggername

Comments