Re: Finding KEY information from schema tables ?

check in the Oracle system dictionnary description at te end of the DBA administrator manual . some of these tables are related to the index and columns used (all_indexes, all_ind_columns, dba_indexes, dba_ind_columns, user_indexes, user_ind_columns for example

In article <wdavies-1102981404110001_at_semantics.stanford.edu>, wdavies_at_cs.stanford.edu (Winton Davies) wrote:
>Hi,
>
> How can I recover schema information (such as Primary Key's , COmposite
>Keys, Secondary Keys and so on?) from both Oracle and Sybase systems ?
>
> I've been looking at ODBC, and can see no function that does this. I'm
>assuming this information is stored in proprietary system tables, but a
>cursory look at a stack of documentation yield no leads....
>
> Thanks a million,
> Winton
>

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Thu Feb 12 1998 - 00:00:00 CST