Database reference - AdventureWorks

AdventureWorks - defaults - [Sales].[DF_Store_ModifiedDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
Store.ModifiedDate	table column

Dependency graph

DF_Store_ModifiedDate Store

Objects that depend on [Sales].[DF_Store_ModifiedDate]

name	object type	level
Store	table	1
iStore	trigger	2
vStoreWithDemographics	view	2
iuIndividual	trigger	2

Code

(getdate())

Powered by Yoyodyne © 1971