Shweta68

Shweta68

  • NA
  • 99
  • 7.9k

The DELETE statement conflicted

Nov 25 2018 6:47 AM
Hi,
 
I write a simple delete query. And execute that query. Then I found below error.
  1. Msg 547, Level 16, State 0, Line 5  
  2. The DELETE statement conflicted with the REFERENCE constraint "FK_tb_state_tb_country". The conflict occurred in database "EmployeeDB", table "dbo.tb_state", column 'country_id'.  
  3. The statement has been terminated. 
Is there any solution for above??

Answers (5)