Sdílet prostřednictvím


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.

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