有办法查出 sql server 2008 列属性中的说明吗
0
最佳答案
0
select col.name as column_name,per.value as column_comment,col.is_identity as column_key ,type.name as data_type from sys.columns col
inner join sys.tables tab on col.object_id=tab.object_id
left join sys.extended_properties per on col.column_id=per.minor_id and per.major_id=tab.object_id
inner join sys.types type on col.user_type_id=type.user_type_id
where tab.name='{TableName}'
收获园豆：5
