/* 創建 到 商家信息表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

*/