select sysobjects.name '表名',syscolumns.name '列名',sysproperties.value '注释' from sysobjects,syscolumns,sysproperties where sysobjects.id = syscolumns.id and sysobjects.xtype = 'U' and syscolumns.id = sysproperties.id and syscolumns.colid = sysproperties.smallid
from sysobjects,syscolumns,sysproperties
where sysobjects.id = syscolumns.id
and sysobjects.xtype = 'U'
and syscolumns.id = sysproperties.id
and syscolumns.colid = sysproperties.smallid