| Subject | Re: How to tell if an index is ascending or descending |
|---|---|
| Author | Stephen Boyd |
| Post date | 2007-09-27T13:12:24Z |
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:
Both the old Interbase Language Reference and Helen's Firebird book
show this field as unused.
<m.tonies@...> wrote:
>Thank you.
>
>
> > Where in the system tables to I find out whether an index is ascending
> > or descending?
>
> RDB$INDICES.RDB$INDEX_TYPE
>
> 0 = ASC
> 1 = DESC
>
Both the old Interbase Language Reference and Helen's Firebird book
show this field as unused.