Subject | Re: [ib-support] Re: Getting information about key fields using gds32 |
---|---|
Author | Helen Borrie |
Post date | 2002-10-15T07:23:28Z |
At 06:06 AM 15-10-02 +0000, you wrote:
heLen
>I ended up finding it out by executing an sql statement:If there is, I haven't heard of it. :-)
>
>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?
heLen