Re: Key Information in Sybase & Oracle

Sure there is, there are whole raft of ODBC API calls to get the database's metadata; how do you think tools like Access/etc. can read the information now?

Winton Davies wrote:
>
> Hi,
>
> As far as I can tell there is no ODBC standard for Key information (and
> Indexing for that matter).
>
> Could anyone from either camp tell me which tables I need to query to
> find primary and foreign keys for a given relation, and also how to find
> out what fields have indexes on them ?
>
> Please email any answers to me, as I rarely get to browse these
> groups...
>
> Cheers,
> Winton
Received on Fri May 22 1998 - 00:00:00 CDT