Subject Re: [firebird-support] Find primary key column names at runtime
Author Yves Glodt
Post date 2005-09-12T09:51:51Z
Martijn Tonies wrote:
> Hi,
>
>
>>I need to find out the primary key column names from a table (at
>>runtime) by querying the system tables (RDB$)... I have looked into but
>>failed to find which tables contain the information I need...
>>
>>Where can I find that information?
>
>
> RDB$INDICES, RDB$INDEX_SEGMENTS and RDB$RELATION_CONSTRAINTS.

Dank u wel!

> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>