如何取得sql server数据库表中各字段的描述:
select so.name,sc.name,sp.value from sysproperties sp
inner join syscolumns sc
on sp.id = sc.id and sp.smallid = sc.colid
left join sysobjects so
on so.id = sc.id
select so.name,sc.name,sp.value from sysproperties sp
inner join syscolumns sc
on sp.id = sc.id and sp.smallid = sc.colid
left join sysobjects so
on so.id = sc.id