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*
1条答案
按热度按时间nbysray51#
这应该可以,请注意我已经使用了类似的运算符(其中col.name类似于“%COLUMN_NAME_HERE %”),因此它将找到匹配的模式,如果您想找到完全匹配,请使用(其中col.name =“COLUMN_NAME_HERE”)