Disable and Enable Foreign key references in Sql Server 2008
-- Disable all table constraints
ALTER TABLE MyTable NOCHECK CONSTRAINT ALL
-- Enable all table constraints
ALTER TABLE MyTable CHECK CONSTRAINT ALL
-- Disable single constraint
ALTER TABLE MyTable NOCHECK CONSTRAINT MyConstraint
-- Enable single constraint
ALTER TABLE MyTable CHECK CONSTRAINT MyConstraint
Showing posts with label Disable and Enable Foreign key references in Sql Server 2008. Show all posts
Showing posts with label Disable and Enable Foreign key references in Sql Server 2008. Show all posts
6 September 2011
Subscribe to:
Posts (Atom)
-
ViewBag, ViewData, TempData and View State in MVC ASP.NET MVC offers us three options ViewData, ViewBag and TempData for passing data from...
-
// Export Datatable to Excel in C# Windows application using System; using System.Data; using System.IO; using System.Windows.Forms; ...
