Dbo.AWBuildVersion (table)

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


wikivalues[edit]

Table Values dbo.AWBuildVersion
SystemInformationID Database Version VersionDate
1 9.06.04.26.00 2006-04-26 00:00:00.000

automatically generated[edit]

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


Column Data Type Nullable Default Description / PK / Index
SystemInformationID tinyint not null Primary key for AWBuildVersion records.
PK_AWBuildVersion_SystemInformationID
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.