帮忙写一条触发器语句（因为急用）

[qingyun27sc]

虽然请别人写语句这样不好，但是确实是有点急用。

有四张表
table_ID
table_information
table_family
table_grade


每个表中都有ID字段。

我想写一个触发器，比如在删除表table_ID的ID=12345的时候，其他表中的ID=12345那条记录也跟着删除 要怎么写呢？

谢谢帮忙 O(∩_∩)O~

[SQL77]

级联就行了,

如果真的要

CREATE TRIGGER TRI_DEL ON table_ID
FOR DELETE 
AS 
  BEGIN 
       DELETE table_information WHERE ID IN(SELECT ID FROM DELETED)
END

[破折号]

create trigger checkID on table_ID for delete
as
delete from table_information where ID=(select ID from deleted)
delete from table_family where ID=(select ID from deleted)
delete from table_grade where ID=(select ID from deleted)

[sgtzzc]

create trigger tri_delete_table_id
on table_id
for delete
as
  delete table_information where id in(select id from deleted);
  delete table_family  where id in(select id from deleted);
  delete table_grade where id in(select id from deleted);
go