--禁用/启用某个数据库的所有表的外键约束

EXEC sp_MSforeachtable @command1='alter table ? NOCHECK constraint all;

EXEC sp_MSforeachtable @command1='alter table ? CHECK constraint all;