Skip to content

Instantly share code, notes, and snippets.

@gustavobgama

gustavobgama/SeachForColumn.sql

Created January 17, 2014 09:43
Show Gist options
  • Save gustavobgama/8470737 to your computer and use it in GitHub Desktop.
Save gustavobgama/8470737 to your computer and use it in GitHub Desktop.
Download ZIP
Search for a column in all tables
Raw
SeachForColumn.sql
SELECT table_name,table_schema FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name='column_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment