Community discussion forum

whats wrong with this query

• • Reply

  7 months ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 2 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
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  6 months ago

  by joe90

  J Alan

  , United Kingdom

  Joined 3 years ago

  Royal,

  Did you try simply using:

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

  ?

   Joe
   

   

  Report abuse
• • Reply

  6 months ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 2 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

  6 months ago

  by joe90

  J Alan

  , United Kingdom

  Joined 3 years ago

  No problemo Royal,

  Glad you got it sorted :)

  Joe 

   

  Report abuse