Server Type - MS SQL Server
Scanerio : Error faced when tried to apply foreign key constraint on table having data in it (non empty table).
Error
Msg 547, Level 16, State 0, Line 20 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "". The conflict occurred in database "", table "dbo.", column '**'
Solution
Empty table first then apply foreign key
No comments:
Post a Comment