From: anilcan@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: oracle table schema
Date: Sat, 11 Nov 2000 18:27:51 GMT
Organization: Deja.com - Before you buy.
Lines: 17
Message-ID: <8uk332$bao$1@nnrp1.deja.com>
References: <8uh58d$3p0$1@nnrp1.deja.com> <D15ED542E12BD3119FFE00805F6551F009EF2B61@mailwhqnews.cerner.com>
NNTP-Posting-Host: 213.243.0.42
X-Article-Creation-Date: Sat Nov 11 18:27:51 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows 98; Anet)
X-Http-Proxy: 1.1 cache (NetCache NetApp/RbrutusN_001009_2145), 1.1 x58.deja.com:80 (Squid/1.1.22) for client 213.243.20.18, 213.243.0.42
X-MyDeja-Info: XMYDJUIDanilcan


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.