Databases > AdventureWorks2019 > Tables > AWBuildVersion

AdventureWorks2019

AWBuildVersion

//
Current version number of the AdventureWorks 2016 sample database.

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    SystemInformationID
    [tinyint] IDENTITY (1,1) NOT NULL
  • //
    ${escapify(column.description)}
    Database Version
    [nvarchar](25) NOT NULL
  • //
    ${escapify(column.description)}
    VersionDate
    [datetime] NOT NULL
  • //
    ${escapify(column.description)}
    ModifiedDate
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • //
    Clustered index created by a primary key constraint.
    PK_AWBuildVersion_SystemInformationID
    UNIQUE CLUSTERED
    SystemInformationID

Sample Data

SystemInformationID
Database Version
VersionDate
ModifiedDate
1
15.0.4280.7