Database reference - AdventureWorks

AdventureWorks - defaults - [Production].[DF_TransactionHistory_TransactionDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
TransactionHistory.TransactionDate	table column

Dependency graph

DF_TransactionHistory_TransactionDate TransactionHistory

Objects that depend on [Production].[DF_TransactionHistory_TransactionDate]

name	object type	level
TransactionHistory	table	1
iduSalesOrderDetail	trigger	2
uPurchaseOrderDetail	trigger	2
iPurchaseOrderDetail	trigger	2
uWorkOrder	trigger	2
iWorkOrder	trigger	2

Code

(getdate())

Powered by Yoyodyne © 1971