sys.sp_help

general

#stored-procedure

Description

Removes one or more user-defined defaults from the current database. : SQL Server ( SQL Server 2016 (13.x) through current version Conditionally drops the default only if it already exists. Is the name of the schema to which the default belongs. Is the name of an existing default. To see a list of defaults that exist, execute must comply with the rules for. Specifying the default schema name is optional. Before dropping a default, unbind the default by executing if the default is currently bound to a column or an alias data type. DROP DEFAULT will be removed in the next version of Microsoft SQL Server. Do not use DROP DEFAULT in new development work, and plan to modify applications that currently use them. Instead, use default definitions that you can create by using the DEFAULT CREATE DEFAULT (Transact-SQL)

Syntax

[Person].
[AddressType]

Remarks

Removes one or more user-defined defaults from the current database.

: SQL Server ( SQL Server 2016 (13.x) through

current version

Conditionally drops the default only if it already exists.

schema_name

Is the name of the schema to which the default belongs.

default_name

Is the name of an existing default. To see a list of defaults that exist, execute

must comply with the rules for

identifiers. Specifying the default schema name is optional.

Before dropping a default, unbind the default by executing

if the default is

currently bound to a column or an alias data type.

DROP DEFAULT will be removed in the next version of Microsoft SQL Server. Do not use

DROP DEFAULT in new development work, and plan to modify applications that currently

use them. Instead, use default definitions that you can create by using the DEFAULT

CREATE DEFAULT (Transact-SQL)

sp_helptext (Transact-SQL)

sp_help (Transact-SQL)

sp_unbindefault (Transact-SQL)

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'
;