【转】SQL Server查询字段说明selectc.name,isnull(ETP.value,'')asDesFROMsyscolumnscinnerjoinsystypestonc.xusertype=t.xusertypeleftjoinsys.extended_PRopertiesETPonETP.major_id=c.idandETP.minor_id=c.colidandETP.name='MS_Description'leftjoinsyscommentsCMonc.cdefault=CM.idwherec.id=object_id('表名')