Question

创建一触发器，当删除Reader表中读者的信息时，同时删除Borrow表中该读者的记录。 用SQL语句

Answer 1

1楼的，别人是删除啦
create trigger 触发器名称
on reader
for delete
as
delete * from borrow where borrower.读者ID = deleted.读者ID

Answer 2

create trigger 触发器名称
on Reader
for Instead of delete
as
delte * from borrow where borrow.字段名=instead.关联字段名

Answer 3

oracle的
create or replace trigger 触发器名称
after delete on reader
for each row
begin
delete from borrow where borrower.读者ID = :old.读者id;
dbms_output.put_line('读者信息已删除');
end 触发器名称;