Database reference - AdventureWorks

AdventureWorks - defaults - [Production].[DF_WorkOrder_ModifiedDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
WorkOrder.ModifiedDate	table column

Dependency graph

DF_WorkOrder_ModifiedDate WorkOrder

Objects that depend on [Production].[DF_WorkOrder_ModifiedDate]

name	object type	level
WorkOrder	table	1
iWorkOrder	trigger	2
uWorkOrder	trigger	2

Code

(getdate())

Powered by Yoyodyne © 1971