select
TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
where CONSTRAINT_SCHEMA ='blog' AND
REFERENCED_TABLE_NAME = 'articles';
+------------+-------------+----------------------+-----------------------+------------------------+
| TABLE_NAME | COLUMN_NAME | CONSTRAINT_NAME | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME |
+------------+-------------+----------------------+-----------------------+------------------------+
| categories | uuid | fk_articles_category | articles | category_uuid |
+------------+-------------+----------------------+-----------------------+------------------------+
alter tablecategories drop foreign key fk_articles_category;
如果这篇文章对你有所帮助,可以通过下边的“打赏”功能进行小额的打赏。
本网站部分内容来源于互联网,如有侵犯版权请来信告知,我们将立即处理。