Database reference - AdventureWorks

AdventureWorks - defaults - [HumanResources].[DF_JobCandidate_ModifiedDate]

Description

Default constraint value of GETDATE()

Bindings

name	type
JobCandidate.ModifiedDate	table column

Dependency graph

DF_JobCandidate_ModifiedDate JobCandidate

Objects that depend on [HumanResources].[DF_JobCandidate_ModifiedDate]

name	object type	level
JobCandidate	table	1
vJobCandidateEmployment	view	2
vJobCandidateEducation	view	2
vJobCandidate	view	2

Code

(getdate())

Powered by Yoyodyne © 1971