Para habilitar utilize o comando:
ALTER TABLE tableName NOCHECK CONSTRAINT ALL
Para reabilitar utilize o comando:
ALTER TABLE tableName WITH CHECK CHECK CONSTRAINT ALL
Obs: substituir o tableName pelo nome da sua tabela.
Desabilitar e Reabilitar constraint SQL Server
This entry was posted in SQL and tagged Constraint, SQL, SQL Server. Bookmark the <a href="https://www.ctasoftware.com.br/blog/desabilitar-e-reabilitar-constraint-sql-server/" title="Permalink to Desabilitar e Reabilitar constraint SQL Server" rel="bookmark">permalink</a>.