sys.sp_helpconstraint

Description

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 Specifies the table for which the constraint information is returned. , with no default. The table specified must be local to the current database. An optional parameter that prints the table name.

Syntax

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

Examples

Example 1

sp_help <table>

Example 2

sp_helpconstraint

Example 3

AdventureWorks2025

Example 4

AdventureWorksDW2025

Example 5

Product.Product

Example 6

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