Tables [dbo].[C2OFlowChart]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count27
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
RoiEnabletinyint1
Yes
((1))
ObjectIDint4
No
ManualCostvarchar(10)10
Yes
GrpNamevarchar(50)50
Yes
Criticalityvarchar(20)20
Yes
ManualExecCostvarchar(10)10
Yes
SQL Script
CREATE TABLE [dbo].[C2OFlowChart]
(
[RoiEnable] [tinyint] NULL CONSTRAINT [DF__C2OFlowCh__RoiEn__2C3393D0] DEFAULT ((1)),
[ObjectID] [int] NOT NULL,
[ManualCost] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GrpName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Criticality] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManualExecCost] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Uses