Re: oracle table schema

From: <anilcan_at_my-deja.com>
Date: Sat, 11 Nov 2000 18:27:51 GMT
Message-ID: <8uk332$bao$1@nnrp1.deja.com>

thanks for your help but i couldnt find the list of columns that an index contains. how can i find it with SQL?

"Gosch,Jody" <JGOSCH_at_cerner.com> wrote:
> select * from all_tab_columns where table_name = <your table name>
will
> give you the columsn for a particular table.
> select * from all_indexes where table_name = <your table name> will
give
> you all the indexes for a particular table
> select * from all_constraints where table_name = <your table name>
will
> give you constraints.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 11 2000 - 12:27:51 CST