Skip to content

Instantly share code, notes, and snippets.

@jeffbricco

jeffbricco/FindColumnsByName.sql

Created September 27, 2019 20:19
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 jeffbricco/e81f51a019644d1e79b9e39222fb66a9 to your computer and use it in GitHub Desktop.
Save jeffbricco/e81f51a019644d1e79b9e39222fb66a9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
FindColumnsByName.sql
SELECT c.name AS 'ColumnName'
,t.name AS 'TableName'
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%PutWhatYouAreLookingForHere%'
ORDER BY TableName
,ColumnName;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment