Skip to content

Instantly share code, notes, and snippets.

@mourawaldson

mourawaldson/search-field.sql

Created February 16, 2015 00:35
Show Gist options
  • Save mourawaldson/e897b827e4a135f99491 to your computer and use it in GitHub Desktop.
Save mourawaldson/e897b827e4a135f99491 to your computer and use it in GitHub Desktop.
Download ZIP
Search for a field in a db
Raw
search-field.sql
SELECT DISTINCT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%field_name%' AND TABLE_SCHEMA = 'scheme_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment