Board index » delphi » Table reference of foreign key

Peter Schout

Delphi Developer
Fri, 18 Jun 2004 21:02:03 GMT

Table reference of foreign key

Does anybody know how i can determine which table & field a foreign key is pointing at?

I think i have to use one of the system tables like rdb$ref_constraint but i can't figure it out...

Thanx

 
Martijn Tonie

Delphi Developer
Fri, 18 Jun 2004 22:15:14 GMT

Re:Table reference of foreign key


Hi Peter,

A FK is pointing to a particular index. The index name is system defined and
is the InterBase part of implementing a Unique or Primary Key constraint.
With that index, you can browse RDB$INDEX_SEGMENTS and see what fields
belong to it. The FK is pointing to these fields.

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Quote
"Peter Schout" <pcsch...@hotmail.com> wrote in message

news:3c3061cb$1_2@dnews...
Quote

> Does anybody know how i can determine which table & field a foreign key is
pointing at?

> I think i have to use one of the system tables like rdb$ref_constraint but

i can't figure it out...
Quote

> Thanx

Other Threads

1. How to update primary and foreign keys in referenced tables

2. Tables with circular references in foreign key

3. Can't I add a foreign Key that references foreign Key of other Table?

4. Modify Key Field ( when it's foreign key in another table)

5. Foreign keys and multi table forms.

6. How to set foreign key to a table on run-time with PARADOX 7

7. FOREIGN KEY between diferent Tables on Diferent DB

8. alter table question for sql server 7 (changing foreign key)

9. adding a foreign key to a table

10. Retreive the table definition (foreign key...from the BDE)