Properties

Owner:	dbo
Creation Date:	04/26/2006
Located On:	PRIMARY
Data Size KB:	8
Index Size KB:	8
Rows:	1
Description:	Current version number of the AdventureWorks sample database.

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		SystemInformationID	tinyint	1					Primary key for AWBuildVersion records.
		Database Version	nvarchar	25					Version number of the database in 9.yy.mm.dd.00 format.
		VersionDate	datetime	8					Date and time the record was last updated.
		ModifiedDate	datetime	8		(getdate())			Date and time the record was last updated.
		Test	varchar	50
		Test2	nchar	10

Total: 6 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	SystemInformationID	1	1

Indexes

	Index	Primary	Unique	Description
	PK_AWBuildVersion_SystemInformationID			Primary key (clustered) constraint

Total: 1 index(es)

SQL

CREATE TABLE [AWBuildVersion] (
    [SystemInformationID] [tinyint] IDENTITY (1, 1) NOT NULL ,
    [Database Version] [nvarchar] (25) COLLATE Latin1_General_CS_AS NOT NULL ,
    [VersionDate] [datetime] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_AWBuildVersion_ModifiedDate] DEFAULT (getdate()),
    [Test] [varchar] (50) COLLATE Latin1_General_CS_AS NULL ,
    [Test2] [nchar] (10) COLLATE Latin1_General_CS_AS NULL ,
    CONSTRAINT [PK_AWBuildVersion_SystemInformationID] PRIMARY KEY  CLUSTERED
    (
        [SystemInformationID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables