Obtener columnas pertenecientes a un constraint

select a.*, c.part1, c.part2, c.part3 from syscolumns a, sysconstraints b, sysindexes c
where a.tabid = b.tabid and b.tabid = c.tabid and b.idxname = c.idxname
and b.constrname like 'pk_tblsolicitud_prod_detalle1'