Database reference - AdventureWorks

AdventureWorks -  defaults -  [Person].[DF_ContactType_ModifiedDate]

Description

Default constraint value of GETDATE() 

Bindings

nametype
ContactType.ModifiedDatetable column

Dependency graph

DF_ContactType_ModifiedDateContactType

Objects that depend on [Person].[DF_ContactType_ModifiedDate]

nameobject typelevel
ContactTypetable1
vStoreWithDemographicsview2
vVendorview2
ufnGetContactInformationmulti-statement table valued function2

Code

(getdate())

Powered by Yoyodyne © 1971