Hi Joe, Yup, thats what it means.
I try to make some - what I believe will be useful - documents extracting the info from this mailing list responses. So far it looks more like a construction place but you are free to browse at my site: http://www.knowd.co.jp/staff/nils Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 10:52、Joe Gaffney さんは書きました: > 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 -- --- 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]
