AWBuildVersion Table (AdventureWorks)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

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 Database Version.

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.

Show:
© 2016 Microsoft