删除触发器:
if
exists
(
select
*
from
sysobjects
where
name
=
'
yourtrigger
'
and
type
=
'
TR
'
)
drop trigger dbo.yourtrigger
drop trigger dbo.yourtrigger
禁用触发器:
alter
table
[
database_name.[owner_name
]
.]table_name
{enable | disable } trigger [ trigger_name ]
{enable | disable } trigger [ trigger_name ]