SQL Foreign Key Mapper is a Python script designed to extract foreign key relationships from a SQL dump file and generate SQL queries to add foreign key constraints between related tables. The script ...

Additionally, some database platforms and data loading tools provide graphical user interfaces (GUI) to create and manage foreign key constraints without writing SQL statements.

select tab.table_schema as database_name, tab.table_name, 'Sem FKs' as foreign_keys from information_schema.tables as tab left join information_schema.table_constraints fks on fks.table_schema = ...