Tables [dbo].[ModelItemPolicy]
(local) > ReportServer > Tables > dbo.ModelItemPolicy
Properties
PropertyValue
CollationLatin1_General_CI_AS_KS_WS
Row Count0
Created12:33:31 PM Tuesday, March 06, 2007
Last Modified12:33:31 PM Tuesday, March 06, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK_ModelItemPolicy: IDIDuniqueidentifier16
No
Cluster Key IX_ModelItemPolicy: CatalogItemID\ModelItemIDCatalogItemIDuniqueidentifier16
No
Cluster Key IX_ModelItemPolicy: CatalogItemID\ModelItemIDModelItemIDnvarchar(425)850
No
Foreign Keys FK_PoliciesPolicyID: [dbo].[Policies].PolicyIDPolicyIDuniqueidentifier16
No
Indexes Indexes
NameColumnsUnique
Primary Key PK_ModelItemPolicy: IDPK_ModelItemPolicyID
Yes
Cluster Key IX_ModelItemPolicy: CatalogItemID\ModelItemIDIX_ModelItemPolicyCatalogItemID, ModelItemID
Foreign Keys Foreign Keys
NameNo CheckDeleteColumns
FK_PoliciesPolicyID
Yes
CascadePolicyID->[dbo].[Policies].[PolicyID]
SQL Script
CREATE TABLE [dbo].[ModelItemPolicy]
(
[ID] [uniqueidentifier] NOT NULL,
[CatalogItemID] [uniqueidentifier] NOT NULL,
[ModelItemID] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[PolicyID] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ModelItemPolicy] ADD CONSTRAINT [PK_ModelItemPolicy] PRIMARY KEY NONCLUSTERED ([ID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_ModelItemPolicy] ON [dbo].[ModelItemPolicy] ([CatalogItemID], [ModelItemID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ModelItemPolicy] WITH NOCHECK ADD CONSTRAINT [FK_PoliciesPolicyID] FOREIGN KEY ([PolicyID]) REFERENCES [dbo].[Policies] ([PolicyID]) ON DELETE CASCADE
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved