Database reference - AdventureWorks

AdventureWorks - defaults - [Production].[DF_BillOfMaterials_ModifiedDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
BillOfMaterials.ModifiedDate	table column

Dependency graph

DF_BillOfMaterials_ModifiedDate BillOfMaterials

Objects that depend on [Production].[DF_BillOfMaterials_ModifiedDate]

name	object type	level
BillOfMaterials	table	1
uspGetWhereUsedProductID	stored procedure	2
uspGetBillOfMaterials	stored procedure	2

Code

(getdate())

Powered by Yoyodyne © 1971