detect foreign keys and referenced tables

[jasmad]

hi

anyone know if you can detect if a field is foreign key accessing procedures, functions or properties of TField,
and if not possible by these means it is possible to do this otherwise?

sorry about my english
fault of the google's translator

greetings

[ZEuS]

You can use the RDB$INDICES system table to find out, whether there is a foreign key in the specified table. Then, you can use the RDB$INDEX_SEGMENTS system table to determine, what particular fields belong to the foreign key.

[jasmad]

hi ZEuS

metadata component does not have access to this information?
instead of directly querying the database

[ZEuS]

The TIBCMetadata component does not provide such functionality. Please use the system tables to obtain this information.