Skip to content

Instantly share code, notes, and snippets.

@mos3abof

mos3abof/tables_referencing_my_table.sql

Created August 4, 2014 13:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mos3abof/54c378664bec9d93768f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mos3abof/54c378664bec9d93768f to your computer and use it in GitHub Desktop.
Download ZIP
List tables referencing 'my_table' in 'my_database' MySQL database
Raw
tables_referencing_my_table.sql
select
table_name
from
information_schema.KEY_COLUMN_USAGE
where
table_schema = 'my_database'
and referenced_table_name = 'my_table';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment