Take the 2-minute tour ×  Had an exam today. One question
disturbed me:    • Q: What can a table constraint do that a
column constraint can't do?   • A: My answer was that only a
table constraint can declare a composite primary key.  I guess
this is not the only difference. How to answer this question
more precisely?  share|improve this question This will help you
to understand Table Level VS Column Level Constraints
(social.technet.microsoft.com/wiki/contents/articles/…) –  Kin
Oct 2 '13 at 16:46 @Kin - That article is somewhat misleading.
Once created they are both stored in the same way in SQL Server
and not treated any differently AFAIK. It implies any change in
the row will cause re-evaluation of table level constraints. – 
Martin Smith Oct 2 '13 at 17:21 add comment  closed as off-topic
by Kin, Max Vernon, RolandoMySQLDBA, bluefeet, Mark Storey-Smith
Oct 3 '13 at 22:02    1 Answer  up vote 5 down vote accepted
You've forgotten about other types of constraint than primary
key (also applies to unique, ch