Zamir's Blog: October 2015

Oct

2

SQL Delete From Table With Constraints.

--Make the System ignore the constraint
ALTER TABLE PK_ConstraintsTableName NOCHECK CONSTRAINT ALL

--Now Delete
DELETE
FROM TableName
WHERE WhereClause

--Put the contraints back
ALTER TABLE PK_ConstraintsTableName CHECK CONSTRAINT ALL

Posted 2nd October 2015 by Unknown

0
Add a comment

Blog Archive

20153
- October1
  - SQL Delete From Table With Constraints.
- May2
20141
- December1
20132
- September1
- April1
201213
- December1
- October1
- September1
- August2
- July2
- April1
- February2
- January3
201116
- December3
- November3
- October3
- September1
- August3
- July3
20107
- December1
- November1
- July1
- June4
20091
- January1
200813
- July13

Topics

Loading

Dynamic Views theme. Powered by Blogger. Report Abuse.