CodePaste.NET - Disable/Enable All constraint

Subscribe

Discuss

What's new

What is it

New Snippet

Recent Snippets

Recent Snippets

My Snippets

My Snippets

Web Code

Search Snippets

Search

Sign inor Register

Language: SQL

Disable/Enable All constraint

286 Views

Copy Code

Show/Hide Line Numbers

-- Disable All constraint (FK)
EXECUTE sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO
 
-- Enable
EXECUTE sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL"
GO

by Tareq
April 10, 2010 @ 1:33am

Tags:

constraint, tsql, FK

Description:

Disable or enable All constraint for all table in sql server db

Add a comment

Report Abuse

brought to you by:

West Wind Techologies

If you find this site useful and use it frequently please consider making a donation to support this free service.

Donate