title: How to see contents of Check Constraint
body: <p>Is there a TSQL script that will allow me to see the contents of a constraint. I found a question regarding Oracle but I need a TSQL script.</p>
  
  <p><a href="https://stackoverflow.com/questions/2686353/how-to-see-contents-of-check-constraint-on-oracle">How to see contents of Check Constraint on Oracle</a></p>
  
  <p>I am aware of sys.check_constraints, however, the 'definition' comes back null for all objects. </p>
  
  <pre><code>Select * from sys.check_constraints
  </code></pre>