--sql语句实现级联修改和删除
-- 此代码有点危险,,级联删除少用,,不然到时连数据表中记录怎么少了都不知道
ALTER TABLE [tablename] DROP CONSTRAINT FK_name
ALTER TABLE [tablename] add
CONSTRAINT [FK_name]
FOREIGN KEY
(
[fk_tableid]
) REFERENCES [pk_tablename] (
[pk_tableid]
)
on update cascade on delete cascade