Skip to content

Instantly share code, notes, and snippets.

@code-poel

code-poel/FindTables.sql

Created August 7, 2013 20:25
Show Gist options
  • Save code-poel/6178267 to your computer and use it in GitHub Desktop.
Save code-poel/6178267 to your computer and use it in GitHub Desktop.
Download ZIP
Find tables with columns.
Raw
FindTables.sql
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ( 'column' ) AND TABLE_SCHEMA='database_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment