locked
conflicted with the FOREIGN KEY constrain RRS feed

  • Question

  • Msg 547, Level 16, State 0, Line 1
    The INSERT statement conflicted with the FOREIGN KEY constrain
    Thursday, June 18, 2015 11:49 AM

Answers

  • It looks that your table has a foreign key reference to another table. but that cannot have a value in that column that is not also in the primary key column of the referenced table.

    To identify which column that Foreign Key is on and which column references: 

    Go to SSMS > 

    sp_help 'dbo.tableName'.


    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/


    • Edited by Ahsan KabirMVP Thursday, June 18, 2015 11:57 AM
    • Marked as answer by Staphen Thursday, June 18, 2015 12:12 PM
    Thursday, June 18, 2015 11:57 AM