Listing 1: The sp_showConstraints Stored Procedure

USE Pubs
GO

CREATE PROCEDURE sp_showConstraints (@tableName varchar(50))
AS
BEGIN
SET NOCOUNT OFF
SELECT OBJECT_NAME(constid) 'Constraint Name',
  constid 'Constraint ID',
  CASE (status & 0xF)
    WHEN 1 THEN 'Primary Key'
    WHEN 2 THEN 'Unique'
    WHEN 3 THEN 'Foreign Key'
    WHEN 4 THEN 'Check'
    WHEN 5 THEN 'Default'
    ELSE 'Undefined'
  END 'Constraint Type',
  CASE (status & 0x30)
    WHEN 0x10 THEN 'Column'
    WHEN 0x20 THEN 'Table'
    ELSE 'N/A'
  END 'Level'
  FROM sysconstraints
  WHERE id=OBJECT_ID(@tableName)
SET NOCOUNT ON
END
GO