Database reference - AdventureWorks

AdventureWorks - defaults - [Purchasing].[DF_PurchaseOrderHeader_OrderDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
PurchaseOrderHeader.OrderDate	table column

Dependency graph

DF_PurchaseOrderHeader_OrderDate PurchaseOrderHeader

Objects that depend on [Purchasing].[DF_PurchaseOrderHeader_OrderDate]

name	object type	level
PurchaseOrderHeader	table	1
uPurchaseOrderHeader	trigger	2
uPurchaseOrderDetail	trigger	2
iPurchaseOrderDetail	trigger	2

Code

(getdate())

Powered by Yoyodyne © 1971