more problems with listing pks and fks

From: <Thenardier_at_POBoxes.com>
Date: 1998/09/16
Message-ID: <6tnimn$ugb$1_at_nnrp1.dejanews.com>#1/1


hi,

[Quoted] [Quoted] i asked u people about how to list pks and fks of a tables and [Quoted] 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

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 16 1998 - 00:00:00 CEST

Original text of this message