Re: Detecting an index

On 7 Jan 2002 10:59:15 -0800, brent_at_interactivetools.com (brent) wrote:

>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

DBA_INDEXES
ALL_INDEXES
USER_INDEXES Brian Received on Mon Jan 07 2002 - 13:14:22 CST