Tables [dbo].[CMS_LOCKS6]
Properties
PropertyValue
HeapYes
Row Count0
Created1:09:12 PM Thursday, March 25, 2010
Last Modified1:09:12 PM Thursday, March 25, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes CMS_LOCKS6_I0: PARENTIDPARENTIDint4
No
Indexes CMS_LOCKS6_I1: CHILDIDCHILDIDint4
No
Indexes CMS_LOCKS6_I4: ISMEMBERISMEMBERint4
No
Indexes CMS_LOCKS6_I3: ORDINALORDINALint4
Yes
Indexes CMS_LOCKS6_I2: RELATIONSHIPIDRELATIONSHIPIDint4
No
VERSIONint4
Yes
DATAimagemax
Yes
Indexes Indexes
NameColumns
CMS_LOCKS6_I0PARENTID
CMS_LOCKS6_I1CHILDID
CMS_LOCKS6_I2RELATIONSHIPID
CMS_LOCKS6_I3ORDINAL
CMS_LOCKS6_I4ISMEMBER
SQL Script
CREATE TABLE [dbo].[CMS_LOCKS6]
(
[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_LOCKS6_I1] ON [dbo].[CMS_LOCKS6] ([CHILDID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_LOCKS6_I4] ON [dbo].[CMS_LOCKS6] ([ISMEMBER]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_LOCKS6_I3] ON [dbo].[CMS_LOCKS6] ([ORDINAL]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_LOCKS6_I0] ON [dbo].[CMS_LOCKS6] ([PARENTID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [CMS_LOCKS6_I2] ON [dbo].[CMS_LOCKS6] ([RELATIONSHIPID]) ON [PRIMARY]
GO
Uses