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

From dbscript Online Help
Jump to: navigation, search
Line 54: Line 54:
 
| SystemInformationID
 
| SystemInformationID
 
|}
 
|}
 
 
 
== wikivalues ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| dbo.AWBuildVersion
 
| dbo.AWBuildVersion
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
|- style="background:silver"
 
 
| '''SystemInformationID
 
| '''SystemInformationID
 
| '''Database Version
 
| '''Database Version
 
| '''VersionDate
 
| '''VersionDate
|-  
+
|- valign="top"
| 1
+
 
| 9.06.04.26.00
+
| 1
| 2006-04-26 00:00:00.000
+
| 9.06.04.26.00
 +
| 2006-04-26 00:00:00.000
 
|}
 
|}
  

Revision as of 23:18, 23 June 2010

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.