Database reference - AdventureWorks

AdventureWorks - defaults - [Purchasing].[DF_Vendor_ModifiedDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
Vendor.ModifiedDate	table column

Dependency graph

DF_Vendor_ModifiedDate Vendor

Objects that depend on [Purchasing].[DF_Vendor_ModifiedDate]

name	object type	level
Vendor	table	1
dVendor	trigger	2
vVendor	view	2

Code

(getdate())

Powered by Yoyodyne © 1971