Dbo.AWBuildVersiontable

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table dbo.AWBuildVersion
Description Current version number of the AdventureWorks sample database.

Columns[edit]

Column Data Type Nullable Default Description
SystemInformationID tinyint not null Primary key for AWBuildVersion records.
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 record was last updated.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_AWBuildVersion_SystemInformationID SystemInformationID