How can I delete FK

essa2000 · Jun 23, 2001

Dears;
I want to create FK using ALTER TABLE and then after creation I want to delete this FK.
How can I delete this run time FK.

essa2000

tlbroadbent · Jun 23, 2001

Do you mean that you want to delete a row using a FK or drop the FK? Terry

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

essa2000 · Jun 24, 2001

No , I want to Foreign Key object itself.

rajeevnandanmishra · Jun 25, 2001

Hi essa2000,
May be this can solve your problem.

ALTER TABLE myTable
DROP CONSTRAINT myForgeinKeyConstraintName