sp_helpconstraint (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

Returns a list of all constraint types, their user-defined or system-supplied name, the columns on which they're defined, and the expression that defines the constraint (for DEFAULT and CHECK constraints only).

Transact-SQL syntax conventions

Syntax

sp_helpconstraint
    [ @objname = ] N'objname'
    [ , [ @nomsg = ] 'nomsg' ]
[ ; ]

Arguments

[ @objname = ] N'objname'

Specifies the table for which the constraint information is returned. @objname is nvarchar(776), with no default. The table specified must be local to the current database.

[ @nomsg = ] 'nomsg'

An optional parameter that prints the table name. @nomsg is varchar(5), with a default of msg. nomsg suppresses the printing.

Return code values

0 (success) or 1 (failure).

Result set

sp_helpconstraint displays a descending indexed column if it participated in primary keys. The descending indexed column is listed in the result set with a minus sign (-) following its name. The default, an ascending indexed column, is listed by its name alone.

Remarks

Executing sp_help <table> reports all information about the specified table. To see only the constraint information, use sp_helpconstraint.

Permissions

Requires membership in the public role.

Examples

The Transact-SQL code samples in this article use the AdventureWorks2022 or AdventureWorksDW2022 sample database, which you can download from the Microsoft SQL Server Samples and Community Projects home page.

The following example shows all constraints for the Product.Product table.

USE AdventureWorks2022;
GO
EXEC sp_helpconstraint 'Production.Product';