CODE EXAMPLE FOR SQL

get foreign table names mysql

select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = '<table>';