Object type: Table

Current version number of the AdventureWorks sample database.

Columns 

Name	Data type	Nullable	Description
SystemInformationID	tinyint	No	Column has identity seed value of 1 with a step value of 1. Primary key for AWBuildVersion records.
Database Version	nvarchar(25)	No	Version number of the database in 9.yy.mm.dd.00 format.
VersionDate	datetime	No	Date and time the record was last updated.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_AWBuildVersion_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_AWBuildVersion_SystemInformationID	PRIMARY KEY	SystemInformationID	Clustered index created by a primary key constraint.

Triggers 

Name	Description
dbo.uAWBuildVersion	AFTER UPDATE trigger setting the ModifiedDate column in the AWBuildVersion table to the current date.

Modified by 

Name	Description
dbo.uAWBuildVersion	AFTER UPDATE trigger setting the ModifiedDate column in the AWBuildVersion table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation