Question
1> Alter Table Department_JCS 2> Add Constraint Department_fk 3> Foreign Key (ManagerSSN) References Employee_JCS(EmployeeSSN) 4> GO Msg 547, Level 16, State 1, Server DESKTOP-54BQ7ENLOCALDB#743D77CD, Line
1> Alter Table Department_JCS 2> Add Constraint Department_fk 3> Foreign Key (ManagerSSN) References Employee_JCS(EmployeeSSN) 4> GO Msg 547, Level 16, State 1, Server DESKTOP-54BQ7EN\LOCALDB#743D77CD, Line 1 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "Department_fk". The conflict occurred in database "master", table "dbo.Employee_JCS", column 'EmployeeSSN'.
How can I get rid of this problem and make a foreign key to with the given variables?
Am I making a syntax error or is it something else?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Larry Ellison Database Genius Of Oracle
Authors: Craig Peters
1st Edition
0766019748, 978-0766019744
