取sql数据库中表的字段的注释等信息

--sql server2000读取备注信息 
SELECT c.name as columnName,p.value as Description FROM sysproperties p join sysobjects o on o.id=p.id 
join syscolumns c on p.id=c.id and p.smallid=c.colid where p.name='MS_Description' and o.name = 'yourtable'


--sql server2005读取备注信息 
select c.name as columnName,p.value as columnDescription from sysobjects o left join syscolumns c  on o.id=c.id
 left join sys.extended_properties p on p.major_id=c.id and p.minor_id=c.colid and p.name='MS_Description' 
where o.type='u' and o.name='YourTableName'