我在尝试删除外键时遇到了一些麻烦.有人可以帮忙吗?
这是我的SHOW CREATE TABLE catgroup:
| catgroup | CREATE TABLE `catgroup` (
`catgroupid` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`catgroupid`),
KEY `category_id` (`category_id`),
KEY `group_id` (`group_id`),
CONSTRAINT `catgroup_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `cat
s` (`cid`) ON UPDATE CASCADE,
CONSTRAINT `catgroup_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups
d`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 |
这就是我试图删除外键的方式:
ALTER TABLE catgroup DROP FOREIGN KEY group_id_ibfk_2;
这是错误信息:
ERROR 1025 (HY000): Error on rename of ‘.\asset_base\catgroup’ to
‘.\asset_base\
sql2-16b4-4′ (errno: 152)
我究竟做错了什么?