Dbo.AWBuildVersion (table)

From dbscript Online Help
Revision as of 23:54, 28 December 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

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.



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.