sql server

To view all the constraints set for a table in MS SQL Server use the built in stored proc:   sp_helpconstraint ‘tablename’