Hello list,

I'm trying to select all column that contain a
foreign key constraint.

I know how to select all FKs and their tablenames
using the following SQL

select
c.rdb$constraint_name,
c.rdb$relation_name
from
rdb$relation_constraints c
where
c.rdb$constraint_type = 'FOREIGN KEY'

But how can I find the column name the FK is on?

I tried to join with RDB$DEPENDENCIES without success.

Thanks in advance && a nice day!

Bastian Ballmann

--
TWC Treuwert Computer GmbH
Schlossbergring 9
79098 Freiburg
Telefon: (07 61) 38 70 70
Fax: (07 61) 23 4 22
Geschäftsführer: Friedrich Westerfeld
Registergericht Freiburg: HRB 1847 - UStIdNr.: DE142114401