Re: droping foreign key

[Chris Tucker]

Upgrading to 4.0.13 will allow you to drop foreign keys.  The innodb manual has 
info:
http://innodb.com/ibman.html

Chris

Joe Gaffney wrote:
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]