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'

Next Post Previous Post