hi all,
I was using the following sql query command to drop the relation(constraint), i used the following command to do this:
ALTER
TABLE [dbo].[tbEmpQualification] DROP CONSTRAINT [FK_tbEmpQualification_tbEmpInfo] FOREIGN KEY([fkEmpCd]) REFERENCES [dbo].[tbEmpInfo] ([pkEmpCd])
But it gives me the following error:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'FOREIGN'.
Can u guide me where I am going wrong.
Regards,
Royal