Re: Key Information in Sybase & Oracle

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: 1998/05/22
Message-ID: <6k49vu$7vj@sjx-ixn8.ix.netcom.com>#1/1

Oracle:
Keys: User_Constraints, Dba_Constraints, User_col_constarints Indexes: User_indexes, Dba_indexes
Sybase, MS SQL:
Keys: sysconstraints
Indexes:sysindexes

HTH
Venkat

> 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