这应该可以，请注意我已经使用了类似的运算符（其中col.name类似于“%COLUMN_NAME_HERE %”），因此它将找到匹配的模式，如果您想找到完全匹配，请使用（其中col.name =“COLUMN_NAME_HERE”）

select 
     schema_name(tab.schema_id) as schema_name
     ,tab.name as table_name
     , col.column_id,col.name as column_name
     , t.name as data_type, col.max_length, col.precision 
from sys.tables as tab 
    inner join sys.columns as col on tab.object_id = col.object_id
    left join sys.types as t on col.user_type_id = t.user_type_id 
where col.name like '%COLUMN_NAME_HERE%' 
order by schema_name,table_name, column_id*