Subject Re: [ib-support] Re: Getting information about key fields using gds32
Author Helen Borrie
At 06:06 AM 15-10-02 +0000, you wrote:

>I ended up finding it out by executing an sql statement:
>
>select rdb$field_name
>from rdb$index_segments, rdb$relation_constraints
>where rdb$index_segments.rdb$index_name =
>rdb$relation_constraints.rdb$index_name
>and rdb$relation_constraints.rdb$constraint_type = 'PRIMARY KEY'
>and rdb$relation_constraints.rdb$relation_name = 'TEST_TABLE'
>
>Is there a better way to do it?

If there is, I haven't heard of it. :-)

heLen