Foreign key ‘FK_OFFICERID’ references invalid column ‘OFFICERID’ in referencing table ‘CARS’ What is the solution to this error?

Arla Bray

5 years ago

ALTER TABLE [dbo].[CARS] WITH CHECK ADD CONSTRAINT FK_OFFICERID FOREIGN KEY ([OFFICERID]) REFERENCES [dbo].OFFICER; GO