Share via


AWBuildVersion Table (AdventureWorks)

Identifies the current version number of the database itself. The database administrators at Adventure Works Cycles use this information as part of their version control plan. For example, they track changes to the schema by using DatabaseVersion.

AWBuildVersion Table Definition

The AWBuildVersion table is contained in dbo.

Column Data type Nullability Description

SystemInformationID

int

Not null

Primary key for AWBuildVersion rows.

Database Version

nvarchar(25)

Not null

Version number of the database in 9.yy.mm.dd.00 format.

VersionDate

datetime

Not null

Date and time the row was last updated.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance