删除mysql表无法删除_无法删除MySQL表

列出外键

select

concat(table_name, '.', column_name) as 'foreign key',

concat(referenced_table_name, '.', referenced_column_name) as 'references'

from

information_schema.key_column_usage

where

referenced_table_name is not null;

对于您的情况下的特定搜索：

select

constraint_name

from

information_schema.key_column_usage

where

referenced_table_name = 'Address' AND referenced_column_name = 'ContactId';

要删除外键约束：

ALTER TABLE [table_name] DROP FOREIGN KEY [constraint_name];