Getting column names for indexes

Hi,

I want to get the column info. for a particular index. Here's my scenario:

There is a table, say address, with a unique index addr_idx0 on (zip, st#, apt#). I would like to know a query which returns me the columns in addr_idx0.

Thanks.

--shirish
(http://www.shaydes.com) Received on Tue Jul 30 2002 - 11:12:51 CDT