Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle table schema
Select * from all_ind_columns where table_name = 'YOUR_TABLENAME' ORDER BY index_owner, index_name, column_position;
<anilcan_at_my-deja.com> wrote in message news:8uk332$bao$1_at_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 - 16:13:02 CST