Hi
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
This should help
Ivo Libal
> -----Urspr=FCngliche Nachricht-----
> Von: Dries Verachtert [SMTP:dries_at_ulyssis.org]
> Gesendet am: Dienstag, 1. August 2000 12:44
> An: Multiple recipients of list ORACLE-L
> Betreff: How to check if a column is a foreign key? If yes, to which
> column
>=20
>=20
> Hello,
>=20
> I'm trying to make a servlet which produces a nice form to fill in a =
new
> row
> of a table when you give it the name of the table as parameter. =
Finding
> the
> names of all the columns in the table and their types seems easy, but =
i
> can't
> find how to check if a column is a foreign key and to which column in
> another table it points.=20
>=20
> Can someone give me some hints on which tables i need to use or if =
you got
> lotsa time, a nice query wich gives me the columnname, the columnname =
in
> the
> referenced table and the name of the referenced table of each =
foreignkey
> in
> a table? :-)
> I'm trying to do this form java with jdbc to a oracle 8i 8.1.6.0 =
database.
> Jdbc has functions like getCrossReferences, getImportedKeys and
> getExportedKeys but that doesn't seem to give the correct output. Any =
idea
> if these functions also should give the output i need?=20
>=20
> I've learned already a lot from this mailinglist. Is there somewhere =
a faq
> of the most asked questions on this list?
>=20
> Thanx in advance,
> Dries Verachtert
>=20
> --=20
> Author: Dries Verachtert
> INET: dries_at_ulyssis.org
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Aug 01 2000 - 05:41:55 CDT
