?? 建商人刪除觸發器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
*/
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -