查看数据库中所有的外键

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;