Skip to content

Instantly share code, notes, and snippets.

@Sam-Gram

Sam-Gram/find table with column name.sql

Created May 21, 2019 23:07
Show Gist options
  • Save Sam-Gram/093dde77396f87d3d0a660779b21a5de to your computer and use it in GitHub Desktop.
Save Sam-Gram/093dde77396f87d3d0a660779b21a5de to your computer and use it in GitHub Desktop.
Download ZIP
Raw
find table with column name.sql
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('column_name') AND TABLE_SCHEMA = 'table_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment