Hi!

I'm trying to find out a way to retrieve the list of indexes for a given Sybase ADS table. So far, found two ways, but none of them seem to work. My guess is that they just work with Sybase, not the Advanced Database Server:

exec sp_helpindex 'tablename'

and

SELECT o.name,
       i.name
  FROM sysobjects o
  JOIN sysindexes i
    ON (o.id = i.id)

also

Execute Procedure sp_mgGetTableIndexes('tablename')

doesn't work. The helpfile says: "Returns a result set containing all indexes opened on the specified table.".

I don't know exactly what they mean by opened.

Any help?

Thanks!