Re: Query to find indexes for a specific table

On 20 Nov 97 at 0:35, Jerry Gitomer wrote: > Is there a query I can set up that will permit our computer > operators to determine if an index exits on a table? I'm swinging in the dark a bit here, but try something like: SELECT * FROM systables, sysindexes, syscolumns WHERE systables.tabid = syscolumns.tabid AND systables.tabid = sysindexes.tabid AND tabname = "your_table_name" AND colname = "your_column_name" AND colno = part1 -- assuming your column is the first part of the index... HTH. -- Ciao, Billy Swanning around in: Johannesburg, Sarf Efrica. Get the Informix FAQs of life at http://www.iiug.org/techinfo/faq/faq_top.html Need to get some drivel into your life? http://www.west.co.za/tasteless/