Database reference - AdventureWorks

AdventureWorks - defaults - [Person].[DF_Address_ModifiedDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
Address.ModifiedDate	table column

Dependency graph

DF_Address_ModifiedDate Address

Objects that depend on [Person].[DF_Address_ModifiedDate]

name	object type	level
Address	table	1
vStoreWithDemographics	view	2
vSalesPerson	view	2
vIndividualCustomer	view	2
vVendor	view	2
vEmployee	view	2

Code

(getdate())

Powered by Yoyodyne © 1971