[dbo].[CMS_RELATIONS6]

Property	Value
Heap
Row Count	4436
Created	1:08:47 PM Thursday, March 25, 2010
Last Modified	1:08:47 PM Thursday, March 25, 2010

Name	Data Type	Max Length (Bytes)
PARENTID	int	4
CHILDID	int	4
ISMEMBER	int	4
ORDINAL	int	4
RELATIONSHIPID	int	4
VERSION	int	4
DATA	image	max

Name	Columns
CMS_RELATIONS6_I0	PARENTID
CMS_RELATIONS6_I1	CHILDID
CMS_RELATIONS6_I2	RELATIONSHIPID
CMS_RELATIONS6_I3	ORDINAL
CMS_RELATIONS6_I4	ISMEMBER

SQL Script

CREATE TABLE [dbo].[CMS_RELATIONS6]
(
[PARENTID] [int] NOT NULL,
[CHILDID] [int] NOT NULL,
[ISMEMBER] [int] NOT NULL,
[ORDINAL] [int] NULL,
[RELATIONSHIPID] [int] NOT NULL,
[VERSION] [int] NULL,
[DATA] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS6_I1] ON [dbo].[CMS_RELATIONS6] ([CHILDID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS6_I4] ON [dbo].[CMS_RELATIONS6] ([ISMEMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS6_I3] ON [dbo].[CMS_RELATIONS6] ([ORDINAL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS6_I0] ON [dbo].[CMS_RELATIONS6] ([PARENTID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_RELATIONS6_I2] ON [dbo].[CMS_RELATIONS6] ([RELATIONSHIPID]) ON [PRIMARY]
GO