Loading ...

How to delete the foreign key constraint of a table

Who is online?  0 guests and 0 members
home  »  forums   »  asp.net topics   »  data access   » How to delete the foreign key constraint of a table

How to delete the foreign key constraint of a table

Posts under the topic: How to delete the foreign key constraint of a table

Posted: 5/11/2010

shawn
shawn watson
Lurker 170  points  Lurker
  • Joined on: 10/17/2009
  • Posts: 34

Hi experts,

I have a requirement  where I need to delete the foreign key constraint of a table, Can you help me in doing so 


tags sql

Posted: 5/11/2010

vinay_jss
Vinay Gupta
Contributor 2255  points  Contributor
  • Joined on: 11/30/2008
  • Posts: 11
  Answered

shawn said:

Hi experts,

I have a requirement  where I need to delete the foreign key constraint of a table, Can you help me in doing so 

 

Hi Shawn,

Use the following query to delete the foreign key constraint of a table.

 

ALTER TABLE TABLE_NAME
DROP FOREIGN KEY FOREIGNKEY_NAME


 
Page 1 of 1 (2 items)