Subject | Re: what is alternative to "show table " ? |
---|---|
Author | Svein Erling Tysvær |
Post date | 2006-03-02T15:22:29Z |
--- In firebird-support@yahoogroups.com, "Mohammad Jeffry" wrote:
picked up at www.fbtalk.net, e.g.
http://www.fbtalk.net/viewtopic.php?id=16
HTH,
Set
> Martijn I still can't figure out how to use the select XXXXIt's a bit more complicated than that. But there are a few hints to be
> 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.
picked up at www.fbtalk.net, e.g.
http://www.fbtalk.net/viewtopic.php?id=16
HTH,
Set