dbo.AWBuildVersion Table

Information

NameAWBuildVersion
Schemadbo
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:33

Extended Properties

NameTypeProperty NameValue
AWBuildVersionTABLEMS_DescriptionCurrent version number of the AdventureWorks sample database.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   SystemInformationIDtinyint   
 
 
 
   Database Versionnvarchar(25) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   VersionDatedatetime   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_AWBuildVersion_SystemInformationIDClustered  SystemInformationID

SQL Script

CREATE TABLE [dbo].[AWBuildVersion] (
    [SystemInformationID] tinyint NOT NULL IDENTITY,
    [Database Version] nvarchar(25) NOT NULL,
    [VersionDate] datetime NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);