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