List foreign keys of a referenced table in mysql or mariadb

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