建立外键时..使用:CRREATE TABLE b(
id int,
name varchar(10),
pwd varchar(10),
CONSTRAINT FK_ID FOREIGNKEY KEY(id) REFERENCES a(id)
ON DELETE CASCADE
);
id int,
name varchar(10),
pwd varchar(10),
CONSTRAINT FK_ID FOREIGNKEY KEY(id) REFERENCES a(id)
ON DELETE CASCADE
);
id int,
name varchar(10),
pwd varchar(10),
CONSTRAINT FK_ID FOREIGN KEY KEY(id) REFERENCES a(id)
ON DELETE CASCADE
);
id int,
name varchar(10),
pwd varchar(10),
CONSTRAINT FK_ID FOREIGN KEY(id) REFERENCES a(id)
ON DELETE CASCADE
);
ON A表
AFTER DELETE
AS
IF @@ROWCOUNT>0
BEGIN
DELETE b
FROM B表 AS b
JOIN DELETED AS d
ON b.id=d.id; DELETE c
FROM C表 AS c
JOIN DELETED AS d
ON c.id=d.id;
END
GO
OUTPUT DELETED.id INTO @T
WHERE id=1;DELETE b
FROM B表 AS b
JOIN @T AS d
ON b.id=d.id;DELETE c
FROM C表 AS c
JOIN @T AS d
ON c.id=d.id;
也可以建立关联时指定on delete cascade