| title | sys.default_constraints (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 096e3659-edeb-4440-a016-f847acd6166b | ||||
| author | VanMSFT | ||||
| ms.author | vanto | ||||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEtsql-appliesto-ss2008-all-md]
Contains a row for each object that is a default definition (created as part of a CREATE TABLE or ALTER TABLE statement instead of a CREATE DEFAULT statement), with sys.objects.type = D.
| Column name | Data type | Description |
|---|---|---|
| <Columns inherited from sys.objects> | For a list of columns that this view inherits, see sys.objects (Transact-SQL). | |
| parent_column_id | int | ID of the column in parent_object_id to which this default belongs. |
| definition | nvarchar(max) | SQL expression that defines this default. |
| is_system_named | bit | 1 = Name was generated by system. 0 = Name was supplied by the user. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
The following example returns the definition of the DEFAULT constraint that is applied to the VacationHours column of the HumanResources.Employee table.
USE AdventureWorks2012;
GO
SELECT d.definition
FROM sys.default_constraints AS d
INNER JOIN sys.columns AS c
ON d.parent_object_id = c.object_id
AND d.parent_column_id = c.column_id
WHERE d.parent_object_id = OBJECT_ID(N'HumanResources.Employee', N'U')
AND c.name = 'VacationHours';
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ