Re: more problems with listing pks and fks

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: 1998/09/18
Message-ID: <360286CE.C5B0FCF1_at_psi.de>#1/1


Our Oracle tool Hora 3 shows all child and all parent tables in a tree view. If you select a constraint of a table Hora shows you all columns belonging to the constraint. You find a free 30 days trial version at http:\\www.keeptool.com

regards Jan Dieckmann
KeepTool GbR

Thenardier_at_POBoxes.com wrote:

> hi,
>
> i asked u people about how to list pks and fks of a tables and
> someone told me to select table name from the all_constraints
> where constraint_type is 'P'. i tried it and find it works fine
> if the table's pk contains only one columns. but if the pk is
> a combination of different columns, it returns no row. what
> should i do?
>
> thanx.
>
> rgds,
> thenard
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 18 1998 - 00:00:00 CEST

Original text of this message