I use this script to extract all fields from all tables.

select so.[Name] 'Table', sc.ColID 'Seq', sc.[Name] 'Field'

FROM syscolumns sc

INNER JOIN sysobjects so ON so.[ID] = sc.[ID]

WHERE so.xtype in (

'IT' /*Internal table*/

,'U' /*User table */

,'V' /*View */

)

ORDER BY so.[Name], sc.ColID, sc.[Name]

I use it to populate an Excel spreadsheet where I put filters on 'Table' and 'Field'.

Filtering on a field name shows all tables with that field

Filtering using 'contains' also shows similarly named fields e.g. all fields containing 'Route'

I can also list all fields in a specific table without going to SSMS.