搞定,谢谢大家!FROM http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html :-------------------------------- Starting from version 4.0.13, InnoDB supports ALTER TABLE DROP FOREIGN KEY internally_generated_foreign_key_id --------------------------------用的时候需要加上表名: alter table TableName drop foreign key ForeignKeyID //////////////////////////////////////////////////////// To swotcoder(苦 丁 www.help2u.org): 个人感觉EMS MySql Manager还挺不错的,与同类相比算是强者。 在2.4版的帮助中并未发现UDF不支持windows?-------------------------------- EMS MySql Manager HelpUDF Editor ..........Availability:
Windows Professional Yes Windows Lite Yes Linux Professional Yes Linux Lite Yes --------------------------------
EMS很多东西有点老旧不堪,比如udf居然从帮助上写着不支持windows。我晕倒!
但你可用建立临时表中转的方法.
在SYSLOG中提供了这一方法.
怎么会用到临时表呢?:)
Starting from version 4.0.13, InnoDB supports ALTER TABLE DROP FOREIGN KEY internally_generated_foreign_key_id
--------------------------------用的时候需要加上表名:
alter table TableName drop foreign key ForeignKeyID
////////////////////////////////////////////////////////
To swotcoder(苦 丁 www.help2u.org):
个人感觉EMS MySql Manager还挺不错的,与同类相比算是强者。
在2.4版的帮助中并未发现UDF不支持windows?--------------------------------
EMS MySql Manager HelpUDF Editor ..........Availability:
Windows Professional Yes
Windows Lite Yes
Linux Professional Yes
Linux Lite Yes
--------------------------------