Difference between revisions of "Dbo.AWBuildVersion (table)"

From dbscript Online Help
Jump to: navigation, search
Line 67: Line 67:
 
| 2006-04-26 00:00:00.000
 
| 2006-04-26 00:00:00.000
 
|}
 
|}
 
 
== automatically generated ==
 
== automatically generated ==
  
Line 89: Line 88:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''Description
+
| '''Description / PK / Index
| '''PK / Index
 
 
 
 
|-
 
|-
Line 97: Line 95:
 
| not null
 
| not null
 
|  
 
|  
| Primary key for AWBuildVersion records.
+
| Primary key for AWBuildVersion records.PK_AWBuildVersion_SystemInformationID
| PK_AWBuildVersion_SystemInformationID
 
 
|-
 
|-
 
| Database Version
 
| Database Version
Line 105: Line 102:
 
|  
 
|  
 
| Version number of the database in 9.yy.mm.dd.00 format.
 
| Version number of the database in 9.yy.mm.dd.00 format.
|
 
 
|-
 
|-
 
| VersionDate
 
| VersionDate
Line 112: Line 108:
 
|  
 
|  
 
| Date and time the record was last updated.
 
| Date and time the record was last updated.
|
 
 
|-
 
|-
 
| ModifiedDate
 
| ModifiedDate
Line 119: Line 114:
 
| (GETDATE())
 
| (GETDATE())
 
| Date and time the record was last updated.
 
| Date and time the record was last updated.
|
 
 
|}
 
|}

Revision as of 23:52, 26 November 2009

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.