Summarize All the Constraints for a Table


The output of the sp_helpconstraint system stored procedure consists of three result sets, so you can't insert the output into a temporary table.Therefore, I created the sp_showConstraints stored procedure as a short and simple alternative to using sp_helpconstraint when I need to find all the constraints for a table.

The sp_showConstraints store procedure analyzes all constraints and summarizes them in a short result set that consists of the constraint name, ID, type, and level. All information is decoded out of the sysconstraints system table.

Listing 1 shows the code for sp_show-Constraints. To use this stored procedure, you call it with code such as

USE pubs
 EXEC sp_showConstraints 'Authors' 

Table 1 shows sample results from sp_showConstraints. I tested this procedure in SQL Server 2005.
— Eli Leiba

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.