analytics/configuration/schemas/logging/sqlserver/LS_dbClean_mssql.sql

-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2005, 2014
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

if exists (select * from sysobjects where id = object_id(N'COGIPF_ACTION') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_ACTION

if exists (select * from sysobjects where id = object_id(N'COGIPF_NATIVEQUERY') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_NATIVEQUERY

if exists (select * from sysobjects where id = object_id(N'COGIPF_PARAMETER') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_PARAMETER

if exists (select * from sysobjects where id = object_id(N'COGIPF_RUNJOB') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_RUNJOB

if exists (select * from sysobjects where id = object_id(N'COGIPF_RUNJOBSTEP') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_RUNJOBSTEP

if exists (select * from sysobjects where id = object_id(N'COGIPF_RUNREPORT') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_RUNREPORT

if exists (select * from sysobjects where id = object_id(N'COGIPF_USERLOGON') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_USERLOGON

if exists (select * from sysobjects where id = object_id(N'COGIPF_VIEWREPORT') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_VIEWREPORT

if exists (select * from sysobjects where id = object_id(N'COGIPF_EDITQUERY') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_EDITQUERY

if exists (select * from sysobjects where id = object_id(N'COGIPF_AGENTRUN') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_AGENTRUN

if exists (select * from sysobjects where id = object_id(N'COGIPF_AGENTBUILD') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_AGENTBUILD

if exists (select * from sysobjects where id = object_id(N'COGIPF_MIGRATION') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_MIGRATION

if exists (select * from sysobjects where id = object_id(N'COGIPF_THRESHOLD_VIOLATIONS') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_THRESHOLD_VIOLATIONS

if exists (select * from sysobjects where id = object_id(N'COGIPF_POWERPLAY') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_POWERPLAY

if exists (select * from sysobjects where id = object_id(N'COGIPF_POWERPLAY_DIM_USAGE') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_POWERPLAY_DIM_USAGE

if exists (select * from sysobjects where id = object_id(N'COGIPF_POWERPLAY_LEVEL_USAGE') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_POWERPLAY_LEVEL_USAGE

if exists (select * from sysobjects where id = object_id(N'COGIPF_POWERPLAY_MEASURE_USAGE') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_POWERPLAY_MEASURE_USAGE

if exists (select * from sysobjects where id = object_id(N'COGIPF_HUMANTASKSERVICE') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_HUMANTASKSERVICE

if exists (select * from sysobjects where id = object_id(N'COGIPF_HUMANTASKSERVICE_DETAIL') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_HUMANTASKSERVICE_DETAIL

if exists (select * from sysobjects where id = object_id(N'COGIPF_ANNOTATIONSERVICE') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_ANNOTATIONSERVICE

if exists (select * from sysobjects where id = object_id(N'COGIPF_MOBILESERVICE') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table  COGIPF_MOBILESERVICE

if exists (select * from sysobjects where id = object_id(N'COGIPF_SYSPROPS') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table COGIPF_SYSPROPS