CODEWITHSUNDEEP
sqlsql-server
harish bhavandla
harish bhavandla

Reputation: 21

How to remove The DELETE statement conflicted with the REFERENCE

I am trying to delete data from table i am getting following error

The DELETE statement conflicted with the REFERENCE constraint "FK_TradingPartnerControlID_TPGRU". The conflict occurred in database "GRiDSCore", table "dbo.TradingPartnerGRU", column 'TradingPartnerControlID'.

Begin Tran
Delete TradingPartnerControl
FROM TradingPartnerGlobalGroup tpgg 
JOIN TradingPartnerGroup tpg ON tpg.TradingPartnerGlobalGroupID = 
tpgg.TradingPartnerGlobalGroupID
JOIN TradingPartnerControl tpc ON tpc.TradingPartnerGroupID = 
tpg.TradingPartnerGroupID
JOIN TradingPartnerGRU tpgru ON tpgru.TradingPartnerControlID = 
tpc.TradingPartnerControlID
JOIn messagecontrol mc on mc.tradingpartnergruid=tpgru.tradingpartnergruid   
where tpc.TradingPartnerControlID between '34' and '39'
--Rollback

I want to delete data from Table TradingPartnerControl where TradingpartnerID between '34' and '39'

Upvotes: 0

Views: 576

Answers (1)

Himanshu
Himanshu

Reputation: 3970

As far as its very clear from the error shown. Its due to foreign key constraint on your column in the table from which you are deleting. Either delete that record first in the referenced table or use CASCADE ...

Upvotes: 1

Related Questions