Tables [dbo].[c2ocommanderobjects]
(local) > itpam > Tables > dbo.c2ocommanderobjects
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count43
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
EarliestStartTimedatetime8
Yes
NodeIDvarchar(100)100
Yes
Cluster Primary Key PK__c2ocommanderobje__3E52440B: ROIDForeign Keys c2ocommanderobjects_ibfk_1: [dbo].[C2ORuntimeObjects].ROIDROIDint4
No
ReferencePathvarchar(7000)7000
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__c2ocommanderobje__3E52440B: ROIDPK__c2ocommanderobje__3E52440BROID
Yes
Foreign Keys Foreign Keys
NameDeleteColumns
c2ocommanderobjects_ibfk_1CascadeROID->[dbo].[C2ORuntimeObjects].[ROID]
SQL Script
CREATE TABLE [dbo].[c2ocommanderobjects]
(
[EarliestStartTime] [datetime] NULL,
[NodeID] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ROID] [int] NOT NULL,
[ReferencePath] [varchar] (7000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[c2ocommanderobjects] ADD CONSTRAINT [PK__c2ocommanderobje__3E52440B] PRIMARY KEY CLUSTERED ([ROID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[c2ocommanderobjects] ADD CONSTRAINT [c2ocommanderobjects_ibfk_1] FOREIGN KEY ([ROID]) REFERENCES [dbo].[C2ORuntimeObjects] ([ROID]) ON DELETE CASCADE
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved