--- In firebird-support@yahoogroups.com, "Mohammad Jeffry" wrote:

> Martijn I still can't figure out how to use the select XXXX
> rdb$relations. what I want is the output of
>
> show tables country
>
> which is this:-
>
> COUNTRY (COUNTRYNAME) VARCHAR(15) Not Null
> CURRENCY VARCHAR(10) Not Null
> CONSTRAINT INTEG_2:
> Primary key (COUNTRY)
>
>
> select * from rdb$relations where rdb$relation_name='country'
>
> The rdb$relations doesn't give me the info I want.

It's a bit more complicated than that. But there are a few hints to be
picked up at www.fbtalk.net, e.g.
http://www.fbtalk.net/viewtopic.php?id=16

HTH,
Set