analytics/configuration/schemas/content/sqlserver/dbClean_mssqlserver.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).


IF EXISTS (select CONSTRAINT_NAME from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = 'CMOBJECTS' and CONSTRAINT_NAME = 'FK_PARENT' and CONSTRAINT_SCHEMA = user_name()) 
BEGIN 
ALTER TABLE CMOBJECTS DROP CONSTRAINT FK_PARENT
END
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 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 proc CMPARSEIDS

drop proc CMPARSECOPYIDS

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;