Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Table key fields

Table key fields

From: Nicolas Prömper <Nicolas.Proemper_at_btconsult.de>
Date: Sun, 13 Mar 2005 20:15:23 +0100
Message-ID: <d123gc$qh0$00$1@news.t-online.com> 





Hi all!



I want to determine the key fields of a table through reading the oracle 
meta data tables. Obviously, ALL_TAB_COLUMNS does not contain a key flag and 
reading the indexes seems not be the right solution.
So, does anyone knows, where the "key-flag" is stored?



Thanks a lot


Nick



P.S: The version I'm currently reading is a 9.1. 
Received on Sun Mar 13 2005 - 13:15:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US