Subject | RE: [firebird-support] Determine whether an index is descending or ascending using RDB$ tables WAS: Finding primary key field RDB$ tables |
---|---|
Author | Svend Meyland Nicolaisen |
Post date | 2005-03-30T22:00:56Z |
> -----Original Message-----Ahh, the column that are descriped as "Reserved for future use" in thr
> From: Alexandre Benson Smith [mailto:iblist@...]
> Sent: 30. marts 2005 23:44
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Determine whether an index is
> descending or ascending using RDB$ tables WAS: Finding
> primary key field RDB$ tables
>
>
> Svend Meyland Nicolaisen wrote:
>
> >Thank you very much for the answer on my previous question.
> Now I have
> >another probably stupid question:
> >
> >How do I determine whether an index is descending or ascending using
> >RDB$ tables?
> >
> >
> >/Svend
> >
> >
> Look at the column RDB$INDEX_TYPE
> 0 or null = ASC
> 1 = DESC
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
InterBase Language Reference?
/Svend