Find Table By Column Name

Quite common task, which I bored to google and as it is not hard to memorize, but decided to record it.

SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS  WHERE COLUMN_NAME LIKE '%DocType%'

Be the first to rate this post

  • Currently 0.0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Comments are provided by Disqus, which sets its own cookies, including for advertising.

Privacy policy | Cookie settings