HI

thank you every one for your answers.

Thats the way I got the answer:

SELECT     sysindexes.id AS IndexID, sysobjects.name AS TableName, sysindexes.name AS IndexName, sysindexes.indid as [Type]

the results are only unique keys. what bout thoso indexes which are not unique or are not keys?