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

From dbscript Online Help
Jump to: navigation, search
Line 12: Line 12:
  
  
 +
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 19:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
| '''Description / PK / Index
+
| '''Description
 
 
 
|- valign="top"
 
|- valign="top"
Line 25: Line 26:
 
| not null
 
| not null
 
|  
 
|  
| Primary key for AWBuildVersion records.<br />PK_AWBuildVersion_SystemInformationID
+
| Primary key for AWBuildVersion records.
 
|- valign="top"
 
|- valign="top"
 
| Database Version
 
| Database Version
Line 31: Line 32:
 
| not null
 
| not null
 
|  
 
|  
| Version number of the database in 9.yy.mm.dd.00 format.<br />
+
| Version number of the database in 9.yy.mm.dd.00 format.
 
|- valign="top"
 
|- valign="top"
 
| VersionDate
 
| VersionDate
Line 37: Line 38:
 
| not null
 
| not null
 
|  
 
|  
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 43: Line 44:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|}
 
|}
 +
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| PK_AWBuildVersion_SystemInformationID
 +
| SystemInformationID
 +
|}
 +
 +
 
== wikivalues ==
 
== wikivalues ==
  

Revision as of 22:52, 2 February 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.