gipasoft

Nocheck constraints

Oct 25th, 2013
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.24 KB | None | 0 0
  1. USE AdventureWorks
  2. GO
  3. -- Disable the constraint
  4. ALTER TABLE HumanResources.Employee
  5. NOCHECK CONSTRAINT CK_Employee_BirthDate
  6. GO
  7. -- Enable the constraint
  8. ALTER TABLE HumanResources.Employee
  9. WITH CHECK CHECK CONSTRAINT CK_Employee_BirthDate
  10. GO
Advertisement
Add Comment
Please, Sign In to add comment