這樣的觸發器怎麽寫?

Question

Create trigger 触发器名 on 表a
For Delete
As
   Delete 表b where id in (select id from deleted)

Answer 1

CREATE TRIGGER test on a
for delete
as
  delete b where id in (select id from deleted)

Answer 2

Create trigger 触发器名 on 表a
For Delete
As
   Delete from 表b where id=deleted.id

Answer 3

CREATE TRIGGER dela
ON a
FOR DELETE
AS 
BEGIN
delete b
         from b,deleted
         where b.id=deleted.id
END