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>';