Re: 7.4 - TODO : alter table drop foreign key

On 5 Dec 2002 at 8:20, Stephan Szabo wrote:

>
> On Thu, 5 Dec 2002, Dan Langille wrote:
>
> > We support "alter table add foreign key". How about supporting
> > "alter table drop foreign key"?
> >
> > - he said as he went to drop a foreign key
>
> It seems to work for me on my 7.3b2 system with
> alter table <table> drop constraint <constraint name>;

Premature send.. sorry

How was that FK added? How did you determine the constraint name?

How would you do that if the FK was added with the following syntax?

alter table <table>
add foreign key (<column>)
references <othertable> (<othercolumn>)
on update cascade on delete cascade;

--
Dan Langille : http://www.langille.org/