However when I look at the structure via phpmyadmin it lists the foreign key with the same name. `status` enum('pending','complete') NOT NULL default 'pending', Navicat Premium Serial key free is a database enhancement device that lets you to simultaneously join with MySQL, MariaDB, rectangular server, oracle, PostgreSQL, and SQLite databases from a single utility. SHOW CREATE TABLE 'table' output: CREATE TABLE `table` ( The Navicat Premium Keygen Download is well suited with cloud databases like Amazon RDS, Amazon Aurora, Amazon redshift, sq. I have run SHOW ENGINE INNODB STATUS which says: 120725 12:38:37 Error in dropping of a foreign key constraint of table db/table,ĪLTER TABLE `table` DROP FOREIGN KEY `fk_table_users1`, DROP FOREIGN KEY `fk_table_accounts1`, DROP FOREIGN KEY `fk_table_data1`Ĭannot find a constraint with the given id fk_table_users1. I am trying to drop a number of foreign keys using: ALTER TABLE `table` DROP FOREIGN KEY `fk_table_users1`, DROP FOREIGN KEY `fk_table_accounts1`, DROP FOREIGN KEY `fk_table_data1` īut it returns the error: Error on rename of './db/table' to './db/#sql2-179c-288289' (errno: 152)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |