Skip to content

Instantly share code, notes, and snippets.

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;

Keybase proof

I hereby claim:

  • I am jeffbricco on github.
  • I am jeffbricco (https://keybase.io/jeffbricco) on keybase.
  • I have a public key ASCjOM1YIsL60jfqCL_dp5VrqwViQQUrYx_1iYf3P9Co2Qo

To claim this, I am signing this object: