foreign key

List foreign keys of a referenced table in mysql or mariadb

Submitted by Fekete Zoltán on Mon, 12/18/2017 - 10:17

mysql> select constraint_name, table_name
       from information_schema.key_column_usage
       where referenced_table_name = '<TABLE_NAME>';