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

Element properties:

Source Code:

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

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

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


DROP INDEX [NCI_ChangeRequestDim_CDateEntityDimKey] ON [dbo].[ChangeRequestDim] 


GO








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


DROP INDEX [NCI2_ChangeRequestDim_CreatedDate] ON [dbo].[ChangeRequestDim] 


GO