How do I see what tables are referencing a primary key?

[Former Member]

Hi, I am trying to work out the indexes and primary key on a table, and I know the primary key is used as a foreign key on other tables, how do I see these references in IQ15?

Thanks,

[Gisung · Accepted solution]

Hi,

Here are associated proc and system table for foreign key.

1) system proc

   - sp_iqpkeys, sp_iqconstraint

2) system table

   - SYSFOREIGNKEY, SYSFOREIGNKEYS

==

HTH

Gi-Sung Jang

[Former Member · Accepted solution]

Hi, thanks, those are useful.