Database reference - AdventureWorks

AdventureWorks -  defaults -  [Person].[DF_StateProvince_ModifiedDate]

Description

Default constraint value of GETDATE() 

Bindings

nametype
StateProvince.ModifiedDatetable column

Dependency graph

DF_StateProvince_ModifiedDateStateProvince

Objects that depend on [Person].[DF_StateProvince_ModifiedDate]

nameobject typelevel
StateProvincetable1
vStoreWithDemographicsview2
vSalesPersonview2
vIndividualCustomerview2
vVendorview2
vStateProvinceCountryRegionview2
vEmployeeview2

Code

(getdate())

Powered by Yoyodyne © 1971