Skip to content

Instantly share code, notes, and snippets.

@Dillie-O

Dillie-O/sql_search_column_name.sql

Created May 24, 2017 14:36
Show Gist options
  • Save Dillie-O/aa7e0e998156902222b1e4a2538abf67 to your computer and use it in GitHub Desktop.
Save Dillie-O/aa7e0e998156902222b1e4a2538abf67 to your computer and use it in GitHub Desktop.
Download ZIP
[Search Database for Column Name] Searches entire database for column name. Can use wildcards #tag:sql
Raw
sql_search_column_name.sql
SELECT * FROM information_schema.COLUMNS WHERE column_name like '%[Column_Name]%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment