The DELETE statement conflicted with the REFERENCE constraint

Page是主表，主键是pageid；UserGroupPage表中的PageID字段是Page表里的数据。 

 

 https://www.codeproject.com/Questions/677277/I-am-getting-error-while-delete-entry

You are trying to Delete the record from a Table which has a reference in another Table.

Here REFERENCE constraint is "FK_User_History_Tbl_Customer".

Tables are User_History and Tbl_Customer.
UserId column is referenced by Tbl_Customer Table.

When you try to delete a row from User_History Table, it comes to know that the same row has some related row in Tbl_Customer Table.

So, you need to delete from Tbl_Customer Table first and then delete from Table User_History.

If you want to delete a row, then you have to execute the following two queries in sequence.

Hide   Copy Code

DELETE FROM Tbl_Customer
WHERE UserId = [[[UserIdToDelete]]];

DELETE FROM User_History
WHERE UserId = [[[UserIdToDelete]]]

 

 

 

尝试筛选了一下数据，居然有记录。本地的开发环境是没有记录的

SELECT *
FROM   dbo.tba_ugp_UserGroupPage AS c
WHERE  EXISTS (   SELECT a.PageID
                  FROM   dbo.tbx_pag_Page AS a
                         INNER JOIN dbo.tbx_mod_Module AS b ON a.ModuleID = b.ModuleID
                  WHERE  b.PhysicalModuleID IN ( 16, 19 )
                         AND a.PageID = c.PageID );

 

作者:Chuck Lu    GitHub