Listing Table Constraints with sp_helpconstraint

For SQL Server metadata, the information schema views may not be suitable for all of your needs. Here is an example involving table constraints.