ServiceManager.Report.Common.SP.ReportOptimizations.Uninstall (Resource)

Element properties:

Source Code:

<Resource ID="ServiceManager.Report.Common.SP.ReportOptimizations.Uninstall" Accessibility="Public" FileName="ServiceManager.Report.Common.SP.ReportOptimizations.Uninstall.sql"/>

File Content: ServiceManager.Report.Common.SP.ReportOptimizations.Uninstall.sql

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WorkItemDim]') AND name = N'NCI0_WorkItemDim')


DROP INDEX [NCI0_WorkItemDim] ON [dbo].[WorkItemDim] 


GO








IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WorkItemDim]') AND name = N'NCI1_WorkItemDim')


DROP INDEX [NCI1_WorkItemDim] ON [dbo].[WorkItemDim] 


GO








IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ManagedTypeDim]') AND name = N'NCI0_ManagedTypeDim')


DROP INDEX [NCI0_ManagedTypeDim] ON [dbo].[ManagedTypeDim] 


GO








IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[UserDim]') AND name = N'NCI0_UserDim')


DROP INDEX [NCI0_UserDim] ON [dbo].[UserDim]


GO








IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ConfigItemDim]') AND name = N'NCI0_ConfigItemDim')


DROP INDEX [NCI0_ConfigItemDim] ON [dbo].[ConfigItemDim]


GO








IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ComputerDim]') AND name = N'NCI0_ComputerDim')


DROP INDEX [NCI0_ComputerDim] ON [dbo].[ComputerDim]


GO