analytics/configuration/schemas/content/db2/dbClean_db2.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2019
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


ALTER TABLE CMOBJECTS DROP CONSTRAINT FK_PARENT;

drop trigger CM_ONMOVE_TR;

drop trigger CM_UNNAMEU_TR;

drop trigger CM_UNNAMEI_TR;

drop trigger CMGUIDS_TR;

drop view CMOWNERCOUNT;

drop table CMOBJECTS;

drop table CMOBJECTS_OLD;

drop table CMOBJNAMES;

drop table CMOBJNAMES_OLD;

drop table CMDATA;

drop table CMDATA_OLD;

drop table CMOBJPROPS1;

drop table CMOBJPROPS1_OLD;

drop table CMOBJPROPS2;

drop table CMOBJPROPS2_OLD;

drop table CMOBJPROPS3;

drop table CMOBJPROPS3_OLD;

drop table CMOBJPROPS4;

drop table CMOBJPROPS4_OLD;

drop table CMOBJPROPS5;

drop table CMOBJPROPS5_OLD;

drop table CMOBJPROPS6;

drop table CMOBJPROPS6_OLD;

drop table CMOBJPROPS6A;

drop table CMOBJPROPS6A_OLD;

drop table CMOBJPROPS7;

drop table CMOBJPROPS7_OLD;

drop table CMOBJPROPS8;

drop table CMOBJPROPS8_OLD;

drop table CMOBJPROPS9;

drop table CMOBJPROPS9_OLD;

drop table CMOBJPROPS10;

drop table CMOBJPROPS10_OLD;

drop table CMOBJPROPS11;

drop table CMOBJPROPS11_OLD;

drop table CMOBJPROPS12;

drop table CMOBJPROPS12_OLD;

drop table CMOBJPROPS13;

drop table CMOBJPROPS13_OLD;

drop table CMOBJPROPS14;

drop table CMOBJPROPS14_OLD;

drop table CMOBJPROPS15;

drop table CMOBJPROPS15_OLD;

drop table CMOBJPROPS16;

drop table CMOBJPROPS16_OLD;

drop table CMOBJPROPS17;

drop table CMOBJPROPS17_OLD;

drop table CMOBJPROPS18;

drop table CMOBJPROPS18_OLD;

drop table CMOBJPROPS19;

drop table CMOBJPROPS19_OLD;

drop table CMOBJPROPS20;

drop table CMOBJPROPS20_OLD;

drop table CMOBJPROPS21;

drop table CMOBJPROPS21_OLD;

drop table CMOBJPROPS22;

drop table CMOBJPROPS22_OLD;

drop table CMOBJPROPS23;

drop table CMOBJPROPS23_OLD;

drop table CMOBJPROPS24;

drop table CMOBJPROPS24_OLD;

drop table CMOBJPROPS25;

drop table CMOBJPROPS25_OLD;

drop table CMOBJPROPS26;

drop table CMOBJPROPS26_OLD;

drop table CMOBJPROPS27;

drop table CMOBJPROPS27_OLD;

drop table CMOBJPROPS28;

drop table CMOBJPROPS28_OLD;

drop table CMOBJPROPS30;

drop table CMOBJPROPS30_OLD;

drop table CMOBJPROPS31;

drop table CMOBJPROPS31_OLD;

drop table CMOBJPROPS32;

drop table CMOBJPROPS32_OLD;

drop table CMOBJPROPS33;

drop table CMOBJPROPS33_OLD;

drop table CMOBJPROPS34;

drop table CMOBJPROPS34_OLD;

drop table CMOBJPROPS35;

drop table CMOBJPROPS35_OLD;

drop table CMOBJPROPS36;

drop table CMOBJPROPS36_OLD;

drop table CMOBJPROPS37;

drop table CMOBJPROPS37_OLD;

drop table CMOBJPROPS38;

drop table CMOBJPROPS38_OLD;

drop table CMOBJPROPS39;

drop table CMOBJPROPS39_OLD;

drop table CMOBJPROPS40;

drop table CMOBJPROPS40_OLD;

drop table CMOBJPROPS41;

drop table CMOBJPROPS41_OLD;

drop table CMOBJPROPS42;

drop table CMOBJPROPS42_OLD;

drop table CMOBJPROPS43;

drop table CMOBJPROPS43_OLD;

drop table CMOBJPROPS44;

drop table CMOBJPROPS44_OLD;

drop table CMOBJPROPS45;

drop table CMOBJPROPS45_OLD;

drop table CMOBJPROPS46;

drop table CMOBJPROPS46_OLD;

drop table CMOBJPROPS47;

drop table CMOBJPROPS47_OLD;

drop table CMOBJPROPS48;

drop table CMOBJPROPS48_OLD;

drop table CMOBJPROPS49;

drop table CMOBJPROPS49_OLD;

drop table CMOBJPROPS50;

drop table CMOBJPROPS50_OLD;

drop table CMOBJPROPS51;

drop table CMOBJPROPS51_OLD;

drop table CMOBJPROPS52;

drop table CMOBJPROPS52_OLD;

drop table CMOBJPROPS53;

drop table CMOBJPROPS53_OLD;

drop table CMOBJPROPS54;

drop table CMOBJPROPS54_OLD;

drop table CMOBJPROPS55;

drop table CMOBJPROPS55_OLD;

drop table CMOBJPROPS56;

drop table CMOBJPROPS56_OLD;

drop table CMOBJPROPS57;

drop table CMOBJPROPS57_OLD;

drop table CMOBJPROPS58;

drop table CMOBJPROPS58_OLD;

drop table CMOBJPROPS59;

drop table CMOBJPROPS59_OLD;

drop table CMOBJPROPS60;

drop table CMOBJPROPS60_OLD;

drop table CMOBJPROPS61;

drop table CMOBJPROPS61_OLD;

drop table CMOBJPROPS62;

drop table CMOBJPROPS62_OLD;

drop table CMOBJPROPS63;

drop table CMOBJPROPS63_OLD;

drop table CMOBJPROPS64;

drop table CMOBJPROPS64_OLD;

drop table CMOBJPROPS65;

drop table CMOBJPROPS65_OLD;

drop table CMOBJPROPS66;

drop table CMOBJPROPS66_OLD;

drop table CMOBJPROPS67;

drop table CMOBJPROPS67_OLD;

drop table CMOBJPROPS68;

drop table CMOBJPROPS68_OLD;

drop table CMOBJPROPS69;

drop table CMOBJPROPS69_OLD;

drop table CMOBJPROPS70;

drop table CMOBJPROPS70_OLD;

drop table CMOBJPROPS71;

drop table CMOBJPROPS71_OLD;

drop table CMOBJPROPS72;

drop table CMOBJPROPS72_OLD;

drop table CMOBJPROPS73;

drop table CMOBJPROPS73_OLD;

drop table CMOBJPROPS74;

drop table CMOBJPROPS74_OLD;

drop table CMOBJPROPS75;

drop table CMOBJPROPS75_OLD;

drop table CMOBJPROPS76;

drop table CMOBJPROPS76_OLD;

drop table CMOBJPROPS77;

drop table CMOBJPROPS77_OLD;

drop table CMOBJPROPS78;

drop table CMOBJPROPS78_OLD;

drop table CMOBJPROPS79;

drop table CMOBJPROPS79_OLD;

drop table CMOBJPROPS80;

drop table CMOBJPROPS80_OLD;

drop table CMOBJPROPS81;

drop table CMOBJPROPS81_OLD;

drop table CMOBJPROPS82;

drop table CMOBJPROPS82_OLD;

drop table CMOBJPROPS83;

drop table CMOBJPROPS83_OLD;

drop table CMOBJPROPS84;

drop table CMOBJPROPS84_OLD;

drop table CMOBJPROPS85;

drop table CMOBJPROPS85_OLD;

drop table CMOBJPROPS86;

drop table CMOBJPROPS86_OLD;

drop table CMOBJPROPS87;

drop table CMOBJPROPS87_OLD;

drop table CMOBJPROPS88;

drop table CMOBJPROPS88_OLD;

drop table CMOBJPROPS89;

drop table CMOBJPROPS89_OLD;

drop table CMOBJPROPS90;

drop table CMOBJPROPS90_OLD;

drop table CMOBJPROPS91;

drop table CMOBJPROPS91_OLD;

drop table CMOBJPROPS92;

drop table CMOBJPROPS92_OLD;

drop table CMOBJPROPS93;

drop table CMOBJPROPS93_OLD;

drop table CMPOLICIES;

drop table CMPOLICIES_OLD;

drop table CMVIEWED;

drop table CMVIEWED_OLD;

drop table CMDELETEDSCHEDULES;

drop table CMDELETEDSCHEDULES_OLD;

drop table CMPROPERTIES;

drop table CMPROPERTIES_OLD;

drop table CMCLASSES;

drop table CMCLASSES_OLD;

drop table CMSYSPROPS;

drop table CMSYSPROPS_OLD;

drop table CMLOCALES;

drop table CMLOCALES_OLD;

drop table CMCRYPTOKEYS;

drop table CMCRYPTOKEYS_OLD;

drop table CMCAKEYS;

drop table CMCAKEYS_OLD;

drop table CMCAPACITY;

drop table CMCAPACITY_OLD;

drop table CMGUIDS;

drop table CMGUIDS_OLD;

drop table CMCAPROPS;

drop table CMCAPROPS_OLD;

drop table CMDBTEST;

drop table CMDBTEST_OLD;

drop table CMREFNOORD1;

drop table CMREFNOORD1_OLD;

drop table CMREFNOORD2;

drop table CMREFNOORD2_OLD;

drop table CMREFORD1;

drop table CMREFORD1_OLD;

drop table CMREFORD2;

drop table CMREFORD2_OLD;

drop table CMSTOREIDS;

drop table CMSTOREIDS_OLD;

drop table CMDATAUPGRADE;

drop table CMDATAUPGRADE_OLD;

drop table CMREFERENCES;

drop table CMREFERENCES_OLD;

drop table CMCHECKCONSISTENCY;

drop table CMCHECKCONSISTENCY_OLD;

drop table CMNOTIFICATIONTABLE;

drop table CMNOTIFICATIONTABLE_OLD;

drop table CMSIZEINFO;

drop table CMSIZEINFO_OLD;

drop table CMSPLIT;

drop table CMARCHIVESTATUS;

drop table CMARCHIVESTATUS_OLD;

drop table  CMARCHIVEQUEUE;

drop table  CMARCHIVEQUEUE_OLD;

drop table CMDELETEQUEUE;

drop table CMDELETEQUEUE_OLD;

drop table CMQUEUELOCK;

drop table CMQUEUELOCK_OLD;

drop table CMTENANTID;

drop table CMTENANTID_OLD;

drop table CMINDEXQUEUE;

drop table CMTAGS;