Re: determing index name

[Bryan Pendleton]

Is there a way to get a list of indexes on a table including the index name.

This sounds like a nice enhancement request for 'show indexes'.

You could also try looking in sys.sysconglomerates.

  SELECT * FROM SYS.SYSCONGLOMERATES

seems to show me the index name, but of course you'll have to do a bit
of system catalog joining and querying to tie that back to your base table.

thanks,

bryan