Re: Help (2nd request) with determining parent key foreign key relationship

In <9kuiob$rqa$1_at_panix1.panix.com> stanb_at_panix.com (Stan Brown) writes:

>In <8daca8eb.0108090930.6e6aa090_at_posting.google.com> j_p_x_at_hotmail.com (OK) writes:
 

>>1. My previous scripts list ALL FOREIGN KEY columns, not PK cols.
>OK, my misunderstanding.
 

>>2. It works no matter how many FKs a table has.
>Yes, I had figured that out, and amended my post.
 

>>3. I simplified a little bit, it gives out all the info for sys schema
>>in less than 1 sec.
>Much faster!
 

>>4. To list the PK cols, you only need to do slightly modification (see
>>below).
>>5. For DBA, I still think the 2nd one is much, much userful.
>Perhaps, but this is for use in a script to be run by non DBA's.
 

>>Here is the output:
 

>>Enter the table name check for foreign key: bonus
 

>>FK Column Name PK Table Name PK Column Name
>>-------------------- ------------------------- --------------------
>>DEPTNO DEPT DEPTNO
>>EMP_NAME, EMP_ID EMP ENAME, EMPNO
One more (small I hope) request. This script is to be used in a perl script, and I need to make the oputput a bit easier to parse.

For the multi column keys it reurns data like this:

XXXX YYYYY XXXX
AAA BBBB That is, the Pk Table name is not repeated. I _think_ this may be because of the "group by"s? In any case I have not been able to hack it suficently to get teh data in the format I need. I will also probably not be able to pass the coulmn fomrat specificatiosn to the DB, are they functionaly important? Or just to make it easier for humans to read? Received on Thu Aug 09 2001 - 15:02:30 CDT