How can I list all constraints for a table?

Question

Since there is no support for NOCHECK/CHECK yet and ce databases do not contains a sys.constraints table, I am wondering how I can return the list of constraints for a given table?  I would like to iterate through them and disable one by one.  Thank you.

Answer 1

Are you looking for INFORMATION_SCHEMA.TABLE_CONSTRAINTS. More information here: http://technet.microsoft.com/en-us/library/ms174156.aspx

---

“This posting is provided "AS IS" with no warranties, and confers no rights”.

Answer 2

Thank you Imran, I believe that will do the trick.