Key Constraint Removal – Foreign Key

In my haste I accidentally linked the Star Trek Actors table to the complement table which resulted in less than ideal output

In order to fix this I need to delete the Foreign Key, so I use:

ALTER TABLE complement

DROP FOREIGN KEY comp2people;

ALTER TABLE complement

ADD CONSTRAINT comp2people

FOREIGN KEY (personID) REFERENCES stactors (actorID);

Realize if I built the sfmembers table and stactors table synchronously this link would have worked