Re: Finding KEY information from schema tables ?

From: David Sisk <davesisk_at_travelin.com>
Date: 1998/02/15
Message-ID: <6c7n0m$skm$1@lal.interserv.com>#1/1

In Oracle, there are hundreds of data dictionary tables to give you the information that you need. Check out USER_CONSTRAINTS and USER_CONS_COLUMNS (or ALL_CONSTRAINTS & ALL_CONS_COLUMNS or DBA_CONSTRAINTS & DBA_CONS_COLUMNS). If you want to see what data dictionary views are available, do a SELECT * FROM DICTIONARY.

Hope this helps,
Dave

Winton Davies wrote in message ...
>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
>
>--
>-----------------------------------------------------------
>E-Mail: wdavies_at_cs.stanford.edu (Winton Davies)
>WWW: http://www.csd.abdn.ac.uk/~wdavies/wdavies.html
>Telephone OFFICE: 1-415-725-7469 (USA) FAX: 1-415-725-7411
>Address: Room 206, Gates, Stanford University, CA 94305, USA
>
Received on Sun Feb 15 1998 - 00:00:00 CST