Database reference - AdventureWorks

AdventureWorks -  defaults -  [HumanResources].[DF_Department_ModifiedDate]

Description

Default constraint value of GETDATE() 

Bindings

nametype
Department.ModifiedDatetable column

Dependency graph

DF_Department_ModifiedDateDepartment

Objects that depend on [HumanResources].[DF_Department_ModifiedDate]

nameobject typelevel
Departmenttable1
vEmployeeDepartmentHistoryview2
vEmployeeDepartmentview2

Code

(getdate())

Powered by Yoyodyne © 1971