get all constraints from mysql

gistfile1.sql

-- helps to debug strange errors like General error: 1005 Can't create table '$some_db.#sql-186d_71' (errno: 121)
-- usually it happens whem you manually rename a table and schema is generated via a tool
-- need to execute also
-- ALTER TABLE `$table`
-- DROP FOREIGN KEY `old_key`,
-- ADD CONSTRAINT `new_key` FOREIGN KEY (field) REFERENCES $table2(id);
SELECT
    constraint_name,
    table_name
FROM
    information_schema.table_constraints
WHERE
    constraint_type = 'FOREIGN KEY'
AND table_schema = DATABASE()
ORDER BY
    constraint_name;