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