怎么通过系统表知道触发器的类型?

怎么通过系统表(而不OBJECTPROPERTY函数)知道触发器的类型?(UPDATE,DELETE,INSERT或它们的组合)

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

SELECT NAME,CASE WHEN
STATUS & 0X2000<>0 THEN 'Y' ELSE NULL END AS [INSTEAD OF],
CASE WHEN
STATUS & 0X400<>0 THEN 'Y' ELSE NULL END AS [INSERT],
CASE WHEN
STATUS & 0X100<>0 THEN 'Y' ELSE NULL END AS [DELETE],
CASE WHEN
STATUS & 0X200<>0 THEN 'Y' ELSE NULL END AS [UPDATE]
FROM SYSOBJECTS
WHERE TYPE='TR'

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus