SELECT  distinct
        b.name  TABLA,
        c.name  COLUMNA,
        isnull(a.value,'')  DESCRIPCIÓN,
        e.name  TIPO,
        case when c.colid = 1 then 'PRIMARY KEY' else '' end    [PRIMARY KEY],
        c.LENGTH    TAMAÑO,
        case when c.isnullable = 1 then 'SI' else 'NO' END  NULLEABLE

FROM    sysobjects b
        inner join syscolumns c
            on  b.id = c.id
        join sys.systypes e
            on  c.xtype = e.xtype
        left join sys.extended_properties a
            on  a.major_id = b.id and
                a.minor_id = c.colid

WHERE   b.type = 'U' and b.name ='I_ATENCION' and e.name<>'NOMBRES' AND        e.name<>'ENTERO' and
        e.name<>'FECHA' AND  e.name<>'MES' AND  e.name<>'MONEDA' and e.name<>'NOMBRES' and
        e.name<>'OBSERVACIONES' and e.name<>'RFC' and e.name<>'STATUS' and e.name<>'TITULOS' and
        e.name<>'TRESCHAR' and e.name<>'CHAR2' and e.name<>'CLAVELARGA' and e.name<>'CURP' and
        e.name<>'comentarios' and e.name<>'VARCHARN' and   e.name<>'ID_T' and   e.name<>'bit' and   e.name='ID_C'

ORDER BY b.name,e.name