mysql数据库表删不掉

SHOW OPEN TABLES WHERE In_use > 0;

SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = 'your_database' AND TABLE_NAME = 'your_table' AND REFERENCED_TABLE_NAME IS NOT NULL;

ALTER TABLE your_table DROP FOREIGN KEY your_foreign_key;

SHOW TRIGGERS WHERE Table = 'your_table';

DROP TRIGGER your_trigger;

SELECT routine_name FROM information_schema.routines WHERE routine_schema = 'your_database' AND routine_type = 'PROCEDURE' AND routine_name LIKE '%your_table%';

SHOW GRANTS FOR 'your_user'@'localhost';

GRANT DROP ON your_database.your_table TO 'your_user'@'localhost';

-- 检查表是否被锁定
SHOW OPEN TABLES WHERE In_use > 0;

-- 检查外键约束
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = 'your_database' AND TABLE_NAME = 'example_table' AND REFERENCED_TABLE_NAME IS NOT NULL;

-- 删除外键约束（如果有）
ALTER TABLE example_table DROP FOREIGN KEY your_foreign_key;

-- 检查触发器
SHOW TRIGGERS WHERE Table = 'example_table';

-- 删除触发器（如果有）
DROP TRIGGER your_trigger;

-- 检查存储过程
SELECT routine_name FROM information_schema.routines WHERE routine_schema = 'your_database' AND routine_type = 'PROCEDURE' AND routine_name LIKE '%example_table%';

-- 删除表
DROP TABLE example_table;