MySQL 4.1 Alpha missing drop foreing key

I have with the greatest interest installed your 4.1 alpha version of your
database server - using INNODB.

It seems as if it is not possible to alter or drop a foreign key after
creation. If this is correct I guess you're missing something very crucial in
this long awaited feature. Alternatively I have missed something cricial. ;-)

Could you please give me a reply and hopefully a solution on this problem, and
I would be much obliged.

Thanx in advance.

Regards

Nikolaj
Ravn



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MySQL 4.1 Alpha missing drop foreing key

Nikolaj Ravn writes:
> I have with the greatest interest installed your 4.1 alpha version of your
> database server - using INNODB.
>
> It seems as if it is not possible to alter or drop a foreign key after
> creation. If this is correct I guess you're missing something very crucial in
> this long awaited feature. Alternatively I have missed something cricial. ;-)
>
> Could you please give me a reply and hopefully a solution on this problem, and
> I would be much obliged.
>
> Thanx in advance.
>
> Regards
>
> Nikolaj
> Ravn

Yes, you are right. The above is doable only with drop / create table
command.

However, this feature is in the works and one of the Next versions of
4.0 and 4.1 will have this workable.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org