建商人删除触发器goods_out.sql

仓库管理系统

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