From dbscript Online Help
wikibot
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.
|
|