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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
