Hey Nils: So that means exporting the data first, then dropping the table, recreating the new table without the foreign key and then finally re-importing the data. Does that sound about right?
Thanks, Joe -----Original Message----- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: 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 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 cgg_goals DROP FOREIGN KEY goal_id > > CREATE TABLE `cgg_goals` ( > `GOAL_ID` int(11) NOT NULL auto_increment, > `GOAL_DESC` varchar(100) default NULL, > `HOUSEHOLD_ID` int(11) NOT NULL default '0', > `RISK_LEVEL_ID` int(11) default '0', > `GOAL_TYP_ID` int(11) default NULL, > `YRS_TO_TARGET` double default '0', > `TARGET_VALUE` double default '0', > `MONTH_INFLOW` double default NULL, > `MONTH_OUTFLOW` double default NULL, > PRIMARY KEY (`GOAL_ID`,`HOUSEHOLD_ID`), > KEY `INDX_HOUSEHOLD_ID` (`HOUSEHOLD_ID`), > KEY `INDX_RISK_LEVEL_ID` (`RISK_LEVEL_ID`), > KEY `INDX_GOAL_ID` (`GOAL_ID`), > FOREIGN KEY (`RISK_LEVEL_ID`) REFERENCES `cgg_risk_level_def` > (`RISK_LEVEL_ID`), > FOREIGN KEY (`GOAL_ID`) REFERENCES `cgg_goal_def` (`GOAL_ID`), > FOREIGN KEY (`HOUSEHOLD_ID`) REFERENCES `cgg_households` (`HOUSEHOLD_ID`) > ) TYPE=InnoDB; > > > I'm using version 4.0.12 running of Win2000 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]