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 table_schema='webcalendar' AND referenced_table_name IS NOT NULL;
查看数据库中所有的外键
最新推荐文章于 2023-08-11 19:02:08 发布