title: How do I get constraints on a SQL Server table column
body: <p>I have a column called <code>MealType</code> (<code>VARCHAR</code>) in my table with a <code>CHECK</code> constraint for <code>{&quot;Veg&quot;, &quot;NonVeg&quot;, &quot;Vegan&quot;}</code></p>
  <p>That'll take care of insertion.</p>
  <p>I'd like to display these options for selection, but I couldn't figure out the SQL query to find out the constraints of a particular column in a table.</p>
  <p>From a first glance at system tables in SQL Server, it seems like I'll need to use SQL Server's API to get the info. I was hoping for a SQL query itself to get it.</p>