触发器格式:
CREATE
trigger
tri_update
on
tablename
for
delete
as
begin
--sql
code
end
例:
CREATE
trigger
tri_update
on
tablename1
--触发的表名
for
delete
as
begin
declare
@del_id
varchar(40)
select
@del_id
=
id
from
deleted
--tablename1
中删除的数据保存在
deleted
中
delete
tablename2
where
id
=
@del_id
--同步删除tablename2中数据
end
-- 查看数据库已有触发器use yourdatabase
go
select * from sysobjects where xtype='TR'
-- 查看单个触发器
exec sp_helptext '触发器名'
--删除触发器:
基本语句如下:
drop trigger trigger_name
删除触发器,DROP TRIGGER trigger_name当然你要有相关权限。装个pl/sql,更简单。
删除表的时候“应该”不会删除响应的触发器的。为验证,你可以验证下,记得验证了告诉我哈。
验证方法:
删除表后查询相关触发器:语句
SELECT TRIGGER_NAME, TRIGGER_TYPE, TRIGGERING_EVENT,
TABLE_OWNER, BASE_OBJECT_TYPE, REFERENCING_NAMES,
STATUS, ACTION_TYPE
FROM all_triggers where TRIGGER_NAME=your_trigger_name
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)