Skip to content

Instantly share code, notes, and snippets.

@jmbeach

jmbeach/search tables 2.sql

Created September 27, 2018 18:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jmbeach/4ed57098360d15d967eef49d2c72491d to your computer and use it in GitHub Desktop.
Save jmbeach/4ed57098360d15d967eef49d2c72491d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
search tables 2.sql
select
c.TABLE_SCHEMA,
c.TABLE_NAME,
c.COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS c
where
c.TABLE_NAME like '%%'
and c.COLUMN_NAME like '%%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment