Database reference - AdventureWorks

AdventureWorks -  defaults -  [HumanResources].[DF_EmployeeDepartmentHistory_ModifiedDate]

Description

Default constraint value of GETDATE() 

Bindings

nametype
EmployeeDepartmentHistory.ModifiedDatetable column

Dependency graph

DF_EmployeeDepartmentHistory_ModifiedDateEmployeeDepartmentHistory

Objects that depend on [HumanResources].[DF_EmployeeDepartmentHistory_ModifiedDate]

nameobject typelevel
EmployeeDepartmentHistorytable1
vEmployeeDepartmentHistoryview2
vEmployeeDepartmentview2

Code

(getdate())

Powered by Yoyodyne © 1971