Tuesday, October 14, 2014

query for Delete CONTRACT OR ACCOUNT FROM IBM MDM


delete from  CONTRACTREL where to_contract_id in  

delete from  CONTRACTREL where from_contract_id in  

delete from  CONTRACTCOMPVAL where contr_component_id in (select contr_component_id from  CONTRACTCOMPONENT where contract_id in (select contract_id from  contract where admin_contract_id in

delete from  ENTITYROLE where role_instance_pk in  

delete from  MISCVALUE  where instance_pk in  

delete from  GROUPINGASSOC   where instance_pk in  

delete from  contractrole where contr_component_id in (select contr_component_id from  CONTRACTCOMPONENT   where contract_id in  

delete from  ACCOUNTADDRESSDETAILS where contr_component_id in (select contr_component_id from  CONTRACTCOMPONENT   where contract_id in  

delete from  xcontractcomponent where contr_component_id in (select contr_component_id from  CONTRACTCOMPONENT   where contract_id in  

delete from  CONTRACTCOMPONENT  where contract_id in  

delete from  CLIENTENTITLEMENT  where contract_id in  

delete from  BILLINGASSOC  where contract_id in  

delete from  CONTRACT where admin_contract_id in 

1 comment:

  1. Some tables might be missing. All users, please do check while using the above query.

    ReplyDelete