create trigger Delete_Fli
after Delete on Plane
for each row
as begin
delete from Flight
where(Plane.PlaneID=Flight.PlaneID);
END;
after Delete on Plane
for each row
as begin
delete from Flight
where(Plane.PlaneID=Flight.PlaneID);
END;
after Delete as begin
delete f from Flight f,Deleted
where(Deleted.PlaneID=Flight.PlaneID); END;
--
--for each row 没有这样的语法
不知道你什么意思 只是你的错误太多了
after Delete
as
begin
delete f from Flight f,Deleted d
whered.PlaneID=Flight.PlaneID) END
刚多了个括号
create trigger Delete_Fli on Plane
after Delete
as
begin
delete f from Flight f,Deleted d
whered.PlaneID=Flight.PlaneIDEND