[dbo].[C2OArchistory]

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

Property

Value

Row Count

157

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)
ROID	int	4
ArchiveDate	datetime	8
ISFAILED	tinyint	1
OID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

ROID

int

ArchiveDate

datetime

ISFAILED

tinyint

OID

int

	Name	Columns	Unique
	PK__C2OArchistory__4F7CD00D	ROID
	archivedate	ArchiveDate

Name

Columns

Unique

PK__C2OArchistory__4F7CD00D

ROID

archivedate

ArchiveDate

Name	Delete	Columns
c2oarchistory_ibfk_1	Cascade	ROID->[dbo].[C2ORuntimeObjects].[ROID]

Name

Delete

Columns

c2oarchistory_ibfk_1

Cascade

ROID->[dbo].[C2ORuntimeObjects].[ROID]

SQL Script

CREATE TABLE [dbo].[C2OArchistory]
(
[ROID] [int] NOT NULL,
[ArchiveDate] [datetime] NULL,
[ISFAILED] [tinyint] NULL,
[OID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OArchistory] ADD CONSTRAINT [PK__C2OArchistory__4F7CD00D] PRIMARY KEY CLUSTERED ([ROID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [archivedate] ON [dbo].[C2OArchistory] ([ArchiveDate]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2OArchistory] ADD CONSTRAINT [c2oarchistory_ibfk_1] FOREIGN KEY ([ROID]) REFERENCES [dbo].[C2ORuntimeObjects] ([ROID]) ON DELETE CASCADE
GO