DB2/400: List of primary and foreign keys within schema

5 pts.
Tags:
AS/400
DB2/400
Foreign keys
How can I get a list of primary and foreign keys within schema in DB2/400?


Software/Hardware used:
DB2/400
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Peterlk,

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatalogtbls.htm
Simple example:
SELECT  * from QSYS2/SYSKEYCST                  
                where TABLE_SCHEMA = ‘JBARON551’

/*   */

Slightly better for you might be:

SELECT * FROM QSYS2.SYSCST
   WHERE TABLE_SCHEMA = 'TRAVEN'
Modify the SELECT list to match your needs.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: