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!