droping foreign key

2003-06-10 Thread Joe Gaffney
Can someone help with trying to remove a foreign key constraint from a table. Each time I run the alter table statement to drop the foreign key I get the following error: Error Code : 1005 Can't create table Here is the table structure and the alter table statement I am executing: ALTER TABLE c

RE: droping foreign key

2003-06-10 Thread Joe Gaffney
: Tuesday, June 10, 2003 9:40 PM To: Joe Gaffney; MySql Subject: Re: droping foreign key HiJoe, thats not supported yet. You will have to recreate the table to remove the foreign key. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 10:13、Joe Gaffney さんは書きました: > Can someone help with try