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

Element properties:

Source Code:

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

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

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


DROP INDEX [NCI_ActivityDim_ADK_EDK] ON [dbo].[ActivityDim]


GO