Hi,

I'm using MYSQL 5.0.22 if I drop forign key constraint it cant deleted and also it doesn't give any errors

this is my code :

alter table <tablename> drop foreign key <fk name>;

pls give solution

could you please do a SHOW CREATE TABLE for that table

CREATE TABLE `cuntstates` (
`st_id` int(11) NOT NULL AUTO_INCREMENT,
`st_name` varchar(100) DEFAULT NULL,
`st_abb` varchar(2) DEFAULT NULL,
`st_cunt_abbr` char(2) NOT NULL,
`st_status` int(11) DEFAULT '1',
PRIMARY KEY (`st_id`),
KEY `fk_stat_cunt_abbr` (`st_cunt_abbr`),
CONSTRAINT `fk_st_cunt_abbr` FOREIGN KEY (`st_cunt_abbr`) REFERENCES `countries` (`ct_abbr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

this is my Create table code

if i delete the Foriegn key fk_st_cunt_abbr it cant deleted

pls give solution

could you show your ALTER statement too please

alter table cuntstates drop foreign key fk_st_cunt_abbr;

that looks like it should work

too bad you used the same name for the foreign key as for the index