How to determine which tables have indexes
Posted on 1999-01-26
I'm using Sybase SQL Server 10.0.2 on AIX
I have a sybase DB and I've used sp_tables to get a list of all the tables.
There are about 50 tables in it, so going through each one is a bit tiresome.
My questions are: How do I determine which tables have indexes in them, how do I tell what the name of those indexes are, and how do I tell what type of index they are (clustered or normal)?
I think it's by using the sp_statistics command, but then what is the exact syntax? I'm running this through the ISQL program.