SELECT o.name,c.Name,i.Name,k.*,i.*
FROM
sysindexes i,
sysindexkeys k,
sysobjects o,
syscolumns c
WHERE o.id=i.id
AND o.xType='U'
AND i.id = k.id
AND i.indid = k.indid
AND i.id = o.id
AND i.id = c.id
AND k.colid = c.colid
--AND o.name='G_Measures'
--AND o.uid=User_ID('DW')
and i.indid > 0
and i.indid < 255
and (i.status & 64)=0
where a.id=b.id and b.type='u'
and a.indid>0
and a.indid<255
and (a.status & 64)=0
from dbo.sysindexes a join dbo.sysobjects b
on a.[id]=b.[id]
where a.indid=0 and b.xtype='U'
group by a.[id],object_name(a.[id])
having count(*)=1