whats wrong with this query

• • Reply

  12 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  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

   

  Report abuse
• • Reply

  12 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  Royal,

  Did you try simply using:

  ALTER TABLE [dbo].[tbEmpQualification] DROP CONSTRAINT [FK_tbEmpQualification_tbEmpInfo]

  ?

   Joe
   

   

  Report abuse
• • Reply

  12 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  hi Joe,

  Nice to see u after a long gap. ya, I got it correct, did the same thing last week. I needed to delete the relation from the Database Diagram. So I directly did it throught the diagram.

  Anyways, thanks for your concern.

  Regards,

  Royal

  Report abuse
• • Reply

  12 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  No problemo Royal,

  Glad you got it sorted :)

  Joe 

   

  Report abuse