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


BEGIN TRANSACTION

delete from CMSYSPROPS

delete from CMCAPACITY

delete from CMDBTEST

delete from CMCRYPTOKEYS

delete from CMCAKEYS

delete from CMCAPROPS

delete from CMOBJECTS

delete from CMOBJNAMES
		
delete from CMDATA

delete from CMOBJPROPS1

delete from CMOBJPROPS2

delete from CMOBJPROPS3

delete from CMOBJPROPS4

delete from CMOBJPROPS5

delete from CMOBJPROPS6

delete from CMOBJPROPS7

delete from CMOBJPROPS9

delete from CMOBJPROPS10

delete from CMOBJPROPS11

delete from CMOBJPROPS13

delete from CMOBJPROPS14

delete from CMOBJPROPS15

delete from CMOBJPROPS16

delete from CMOBJPROPS17

delete from CMOBJPROPS18

delete from CMOBJPROPS20

delete from CMOBJPROPS23

delete from CMOBJPROPS24

delete from CMOBJPROPS25

delete from CMOBJPROPS26

delete from CMOBJPROPS27

delete from CMOBJPROPS28

delete from CMOBJPROPS30

delete from CMOBJPROPS31

delete from CMOBJPROPS32

delete from CMOBJPROPS33

delete from CMOBJPROPS34

delete from CMOBJPROPS35

delete from CMOBJPROPS36

delete from CMOBJPROPS37

delete from CMOBJPROPS38

delete from CMOBJPROPS39

delete from CMOBJPROPS40

delete from CMOBJPROPS41

delete from CMOBJPROPS42

delete from CMOBJPROPS43

delete from CMOBJPROPS44

delete from CMOBJPROPS45

delete from CMOBJPROPS46

delete from CMOBJPROPS47

delete from CMOBJPROPS48

delete from CMOBJPROPS49

delete from CMOBJPROPS50

delete from CMOBJPROPS51

delete from CMOBJPROPS52

delete from CMOBJPROPS53

delete from CMOBJPROPS54

delete from CMOBJPROPS55

delete from CMOBJPROPS56

delete from CMOBJPROPS57

delete from CMOBJPROPS58

delete from CMOBJPROPS59

delete from CMOBJPROPS60

delete from CMOBJPROPS61

delete from CMOBJPROPS62

delete from CMOBJPROPS63

delete from CMOBJPROPS64

delete from CMOBJPROPS65

delete from CMOBJPROPS66

delete from CMOBJPROPS67

delete from CMOBJPROPS68

delete from CMOBJPROPS69

delete from CMOBJPROPS70

delete from CMOBJPROPS71

delete from CMOBJPROPS72

delete from CMOBJPROPS73

delete from CMOBJPROPS74

delete from CMOBJPROPS75

delete from CMOBJPROPS76

delete from CMOBJPROPS77

delete from CMOBJPROPS78

delete from CMOBJPROPS79

delete from CMOBJPROPS80

delete from CMOBJPROPS81

delete from CMOBJPROPS82

delete from CMOBJPROPS83

delete from CMOBJPROPS84

delete from CMOBJPROPS85

delete from CMOBJPROPS86

delete from CMOBJPROPS87

delete from CMOBJPROPS88

delete from CMOBJPROPS89

delete from CMOBJPROPS90

delete from CMOBJPROPS91

delete from CMOBJPROPS92

delete from CMOBJPROPS93

delete from CMPOLICIES

delete from CMVIEWED

delete from CMDELETEDSCHEDULES

delete from CMPROPERTIES

delete from CMCLASSES

delete from CMLOCALES

delete from CMGUIDS

delete from CMREFNOORD1

delete from CMREFNOORD2

delete from CMREFORD1

delete from CMREFORD2

delete from CMSTOREIDS

delete from CMDATAUPGRADE

delete from CMNOTIFICATIONTABLE

delete from CMSIZEINFO

delete from CMSPLIT

delete from CMARCHIVESTATUS

delete from CMARCHIVEQUEUE

delete from CMDELETEQUEUE

delete from CMQUEUELOCK

delete from CMTENANTID

delete from CMINDEXQUEUE

delete from CMTAGS

commit