Database reference - AdventureWorks

AdventureWorks -  defaults -  [HumanResources].[DF_EmployeePayHistory_ModifiedDate]

Description

Default constraint value of GETDATE() 

Bindings

nametype
EmployeePayHistory.ModifiedDatetable column

Dependency graph

DF_EmployeePayHistory_ModifiedDateEmployeePayHistory

Objects that depend on [HumanResources].[DF_EmployeePayHistory_ModifiedDate]

nameobject typelevel
EmployeePayHistorytable1
uspUpdateEmployeeHireInfostored procedure2

Code

(getdate())

Powered by Yoyodyne © 1971