Detecting an index

How does one detect whether an index exists. i.e.
CREATE INDEX table_field_idx ON table (field);

SELECT .... FROM ... WHERE name='table_field_idx';

Thanks in advance Received on Mon Jan 07 2002 - 12:59:15 CST