— Desabilitar todas as chaves estrangeiras (FK) do banco
EXEC sp_msforeachtable ‘ALTER TABLE ? NOCHECK CONSTRAINT all’
— Habilitar todas as chaves estrangeiras (FK) do banco
EXEC sp_msforeachtable ‘ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all’
— Desabilitar todas as chaves estrangeiras (FK) do banco
EXEC sp_msforeachtable ‘ALTER TABLE ? NOCHECK CONSTRAINT all’
— Habilitar todas as chaves estrangeiras (FK) do banco
EXEC sp_msforeachtable ‘ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all’