--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'