Tables [dbo].[CMS_RELATIONS5]
(local) > caswcmbiek > Tables > dbo.CMS_RELATIONS5
Properties
PropertyValue
HeapYes
Row Count109
Created3:30:12 PM Saturday, July 19, 2008
Last Modified3:30:12 PM Saturday, July 19, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes CMS_RELATIONS5_3: PARENTIDPARENTIDnumeric(12,0)9
No
Indexes CMS_RELATIONS5_1: CHILDIDCHILDIDnumeric(12,0)9
No
ISMEMBERnumeric(12,0)9
No
Indexes CMS_RELATIONS5_2: ORDINALORDINALnumeric(12,0)9
Yes
Indexes CMS_RELATIONS5_4: RELATIONSHIPIDRELATIONSHIPIDnumeric(12,0)9
No
Indexes Indexes
NameColumns
CMS_RELATIONS5_1CHILDID
CMS_RELATIONS5_2ORDINAL
CMS_RELATIONS5_3PARENTID
CMS_RELATIONS5_4RELATIONSHIPID
SQL Script
CREATE TABLE [dbo].[CMS_RELATIONS5]
(
[PARENTID] [numeric] (12, 0) NOT NULL,
[CHILDID] [numeric] (12, 0) NOT NULL,
[ISMEMBER] [numeric] (12, 0) NOT NULL,
[ORDINAL] [numeric] (12, 0) NULL,
[RELATIONSHIPID] [numeric] (12, 0) NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS5_1] ON [dbo].[CMS_RELATIONS5] ([CHILDID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS5_2] ON [dbo].[CMS_RELATIONS5] ([ORDINAL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS5_3] ON [dbo].[CMS_RELATIONS5] ([PARENTID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS5_4] ON [dbo].[CMS_RELATIONS5] ([RELATIONSHIPID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved