Dbo.AWBuildVersion (table)

wikibot

Table

dbo.AWBuildVersion

Column	Data Type	Nullable	Default	PK	Index
SystemInformationID	tinyint	not null		PK_AWBuildVersion_SystemInformationID
Database Version	nvarchar(25)	not null
VersionDate	datetime	not null
ModifiedDate	datetime	not null	(getdate())

wikivalues

Table Values

dbo.AWBuildVersion

SystemInformationID	Database Version	VersionDate
1	9.06.04.26.00	2006-04-26 00:00:00.000

automatically generated

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.