more problems with listing pks and fks

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 Wed Sep 16 1998 - 00:00:00 CDT