From: "David Jordan" <djordan@augustmail.com>
Newsgroups: comp.databases.oracle.server
References: <8uh58d$3p0$1@nnrp1.deja.com> <D15ED542E12BD3119FFE00805F6551F009EF2B61@mailwhqnews.cerner.com> <8uk332$bao$1@nnrp1.deja.com>
Subject: Re: oracle table schema
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <XUhP5.9965$Ag1.222022@e420r-sjo2.usenetserver.com>
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
X-Complaints-To: support@usenetserver.com
NNTP-Posting-Date: Sat, 11 Nov 2000 15:23:19 EST
Organization: WebUseNet Corp  http://www.usenetserver.com - Home of the fastest NNTP servers on the Net.
Date: Sat, 11 Nov 2000 14:13:02 -0800


Select * from all_ind_columns where table_name = 'YOUR_TABLENAME'
ORDER BY index_owner, index_name, column_position;


<anilcan@my-deja.com> wrote in message news: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@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.
>