How to view you constraints in MsSql
I tend to forget this little trick, since I don`t use it very often. Anyway, if you want to see the constraints that you have added to a table, then you should open up your SQL Query Analyzer and run the following command
EXEC sp_help
Recent Posts
As well there is sp_helpconstraint although sp_help does seem to give you a bit more…
… back to lurking.