建商人删除触发器goods_in.sql

仓库管理系统

/* 创建 到 商家信息表businessman上 的一个删除goods_in 触发器*/
create trigger businessman_del_in
on businessman
for delete
as
      delete goods_in
      from goods_in,businessman
      where goods_in.bm_id=businessman.bm_id
    


/*if(old.zhibei='零售商') then
      delete 
      from goods_out
      where goods_out.bm_id=old.bm_id
   end if 

create trigger trig_demo1
on teacher
for delete
as
delete course
from course,deleted
where course.tno=deleted.tno

*/