August 17, 2017, 5:52 pm
Do you have problems updating a MSSQL table or removing data from it? This is how you can disable or enable all constrains withing a MSSQL database.
Open an QueryAnalyzer window and make a connection with your MSSQL database.
- To disable all constrains you can execute the following statement:
EXEC sp_MSforeachtable 'alter table ? nocheck constraint all'
- To enable them back you can use:
EXEC sp_MSforeachtable 'alter table ? check constraint all'