sql server中解除与启用外键约束的语句
创建外键:
ALTER TABLE test_sub ADD CONSTRAINT main_id_cons FOREIGN KEY (main_id) REFERENCES test_main;
暂时停用外键约束
ALTER TABLE test_sub NOCHECK CONSTRAINT main_id_cons;
重新启用外键约束
ALTER TABLE test_sub CHECK CONSTRAINT main_id_cons;
删除外键
ALTER TABLE test_sub DROP CONSTRAINT main_id_cons;