Dbo.AWBuildVersion (table)

wikibot

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

Columns

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

Primary Key	Columns
PK_AWBuildVersion_SystemInformationID	SystemInformationID

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.