Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
AWBuildVersion Table (AdventureWorks)
Collapse the table of content
Expand the table of content

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.

Community Additions

ADD
Show:
© 2015 Microsoft