[dbo].[C2OVersion]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	68
Created	11:42:02 AM Friday, March 26, 2010
Last Modified	11:42:02 AM Friday, March 26, 2010

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:42:02 AM Friday, March 26, 2010

Last Modified

11:42:02 AM Friday, March 26, 2010

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Default

DateCreated

datetime

$Indexes compindx: ObjectID\VersionID$

ObjectID

int

((0))

Owner

varchar(255)

255

LastModifiedBy

varchar(255)

255

Comments

varchar(255)

255

IsBaseLine

tinyint

DateModified

datetime

$Indexes compindx: ObjectID\VersionID$

VersionID

varchar(50)

Cluster Primary Key PK_C2OVersion_ID: ID

int

1 - 1

	Name	Columns	Unique
	PK_C2OVersion_ID	ID
	compindx	ObjectID, VersionID

Name

Columns

Unique

PK_C2OVersion_ID

compindx

ObjectID, VersionID

SQL Script

CREATE TABLE [dbo].[C2OVersion]
(
[DateCreated] [datetime] NULL,
[ObjectID] [int] NOT NULL CONSTRAINT [DF__C2OVersio__Objec__108B795B] DEFAULT ((0)),
[Owner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastModifiedBy] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Comments] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsBaseLine] [tinyint] NULL,
[DateModified] [datetime] NULL,
[VersionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ID] [int] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OVersion] ADD CONSTRAINT [PK_C2OVersion_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [compindx] ON [dbo].[C2OVersion] ([ObjectID], [VersionID]) ON [PRIMARY]
GO