Skip to content

Instantly share code, notes, and snippets.

@wldomiciano

wldomiciano/list-tables-with-a-column-in-a-db.sql

Last active May 15, 2020 17:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wldomiciano/0799ee4c8e29b2c3dd4eb3f053597e20 to your computer and use it in GitHub Desktop.
Save wldomiciano/0799ee4c8e29b2c3dd4eb3f053597e20 to your computer and use it in GitHub Desktop.
Download ZIP
Lista todas as tabelas que contenham colunas com um certo nome em um banco de dados em MySQL
Raw
list-tables-with-a-column-in-a-db.sql
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'your_column_name'
AND TABLE_SCHEMA = 'your_database_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment