Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
System Stored Procedures (Transact-SQL)
Database Engine Stored Procedures (Transact-SQL)
sp_add_data_file_recover_suspect_db (Transact-SQL)
sp_addextendedproc (Transact-SQL)
sp_addextendedproperty (Transact-SQL)
sp_add_log_file_recover_suspect_db (Transact-SQL)
sp_addmessage (Transact-SQL)
sp_addtype (Transact-SQL)
sp_addumpdevice (Transact-SQL)
sp_altermessage (Transact-SQL)
sp_attach_db (Transact-SQL)
sp_attach_single_file_db (Transact-SQL)
sp_autostats (Transact-SQL)
sp_batch_params (Transact-SQL)
sp_bindefault (Transact-SQL)
sp_bindrule (Transact-SQL)
sp_bindsession (Transact-SQL)
sp_certify_removable (Transact-SQL)
sp_clean_db_file_free_space (Transact-SQL)
sp_clean_db_free_space (Transact-SQL)
sp_configure (Transact-SQL)
sp_control_plan_guide (Transact-SQL)
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)
sp_create_removable (Transact-SQL)
sp_createstats (Transact-SQL)
sp_datatype_info (Transact-SQL)
sp_db_vardecimal_storage_format (Transact-SQL)
sp_dbcmptlevel (Transact-SQL)
sp_dbmmonitoraddmonitoring (Transact-SQL)
sp_dbmmonitorchangealert (Transact-SQL)
sp_dbmmonitorchangemonitoring (Transact-SQL)
sp_dbmmonitordropalert (Transact-SQL)
sp_dbmmonitordropmonitoring (Transact-SQL)
sp_dbmmonitorhelpalert (Transact-SQL)
sp_dbmmonitorhelpmonitoring (Transact-SQL)
sp_dbmmonitorresults (Transact-SQL)
sp_dbmmonitorupdate (Transact-SQL)
sp_dboption (Transact-SQL)
sp_dbremove (Transact-SQL)
sp_delete_backuphistory (Transact-SQL)
sp_delete_database_backuphistory (Transact-SQL)
sp_depends (Transact-SQL)
sp_detach_db (Transact-SQL)
sp_dropdevice (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
sp_dropextendedproperty (Transact-SQL)
sp_dropmessage (Transact-SQL)
sp_droptype (Transact-SQL)
sp_estimate_data_compression_savings (Transact-SQL)
sp_estimated_rowsize_reduction_for_vardecimal (Transact-SQL)
sp_executesql (Transact-SQL)
sp_get_query_template (Transact-SQL)
sp_getapplock (Transact-SQL)
sp_getbindtoken (Transact-SQL)
sp_help (Transact-SQL)
sp_helpconstraint (Transact-SQL)
sp_helpdb (Transact-SQL)
sp_helpdevice (Transact-SQL)
sp_helpextendedproc (Transact-SQL)
sp_helpfile (Transact-SQL)
sp_helpfilegroup (Transact-SQL)
sp_helpindex (Transact-SQL)
sp_helplanguage (Transact-SQL)
sp_helpserver (Transact-SQL)
sp_helpsort (Transact-SQL)
sp_helpstats (Transact-SQL)
sp_helptext (Transact-SQL)
sp_helptrigger (Transact-SQL)
sp_indexoption (Transact-SQL)
sp_invalidate_textptr (Transact-SQL)
sp_lock (Transact-SQL)
sp_monitor (Transact-SQL)
sp_procoption (Transact-SQL)
sp_recompile (Transact-SQL)
sp_refreshsqlmodule (Transact-SQL)
sp_refreshview (Transact-SQL)
sp_releaseapplock (Transact-SQL)
sp_rename (Transact-SQL)
sp_renamedb (Transact-SQL)
sp_resetstatus (Transact-SQL)
sp_setnetname (Transact-SQL)
sp_settriggerorder (Transact-SQL)
sp_spaceused (Transact-SQL)
sp_tableoption (Transact-SQL)
sp_unbindefault (Transact-SQL)
sp_unbindrule (Transact-SQL)
sp_updateextendedproperty (Transact-SQL)
sp_updatestats (Transact-SQL)
sp_validname (Transact-SQL)
sp_who (Transact-SQL)
sp_unprepare (Transact-SQL)
sp_prepexecrpc (Transact-SQL)
sp_prepexec (Transact-SQL)
sp_prepare (Transact SQL)
sp_execute (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_helpconstraint (Transact-SQL)

SQL Server 2008

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

Topic link iconTransact-SQL Syntax Conventions

Copy 
sp_helpconstraint [ @objname= ] 'table' 
     [ , [ @nomsg= ] 'no_message' ]
[ @objname= ] 'table'

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

[ @nomsg=] 'no_message'

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

0 (success) or 1 (failure)

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

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

Requires membership in the public role.

The following example shows all constraints for the Product table.

Copy 
USE AdventureWorks;
GO
EXEC sp_helpconstraint 'Production.Product';
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.