Skip to content

Instantly share code, notes, and snippets.

@jeffjohnson9046
Created September 30, 2016 16:22
Show Gist options
  • Save jeffjohnson9046/a7f5ea04f8a205ae6e2978229c12b69f to your computer and use it in GitHub Desktop.
Save jeffjohnson9046/a7f5ea04f8a205ae6e2978229c12b69f to your computer and use it in GitHub Desktop.
SELECT DISTINCT TABLE_NAME, TABLE_SCHEMA
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN (/* list of column names go here */)
AND TABLE_SCHEMA IN (/* list of schemas go here */);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment