Skip to content

Instantly share code, notes, and snippets.

@kkoziarski

kkoziarski/find_table_by_column.sql

Created January 18, 2017 07:46
Show Gist options
  • Save kkoziarski/2f4ccd5bf5cc88afbdba19756bd45b05 to your computer and use it in GitHub Desktop.
Save kkoziarski/2f4ccd5bf5cc88afbdba19756bd45b05 to your computer and use it in GitHub Desktop.
Download ZIP
Find all tables containing column with specified name
Raw
find_table_by_column.sql
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME like '%Brand%'
ORDER BY TABLE_NAME, COLUMN_NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment