[dbo].[c2oworkflowsArchive]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	110
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)	Default
mode1	varchar(25)	25
wfDataset	text	max
OID	int	4
DefinitionXml	text	max
compressedDef	tinyint	1	((0))
wfIcnStatesXML	text	max
compressedDs	tinyint	1	((0))

	Name	Columns	Unique
	PK__c2oworkflowsArch__5441852A	OID

Name	Delete	Columns
c2oworkflowsarch_ibfk_1	Cascade	OID->[dbo].[C2ORuntimeObjectsArch].[OID]

SQL Script

CREATE TABLE [dbo].[c2oworkflowsArchive]
(
[mode1] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[wfDataset] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OID] [int] NOT NULL,
[DefinitionXml] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compressedDef] [tinyint] NULL CONSTRAINT [DF__c2oworkfl__compr__52593CB8] DEFAULT ((0)),
[wfIcnStatesXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compressedDs] [tinyint] NULL CONSTRAINT [DF__c2oworkfl__compr__534D60F1] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[c2oworkflowsArchive] ADD CONSTRAINT [PK__c2oworkflowsArch__5441852A] PRIMARY KEY CLUSTERED ([OID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[c2oworkflowsArchive] ADD CONSTRAINT [c2oworkflowsarch_ibfk_1] FOREIGN KEY ([OID]) REFERENCES [dbo].[C2ORuntimeObjectsArch] ([OID]) ON DELETE CASCADE
GO