Hi,

> 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'
>
> give me this:-
>
> RDB$VIEW_BLR RDB$VIEW_SOURCE RDB$DESCRIPTION

--8<--

> The rdb$relations doesn't give me the info I want.

Ah, that is true.

Well, here's one thing:

- you will not get a complete DDL statement from any command in Firebird.

Column info can be found by joining RDB$RELATION_FIELDS,
RDB$FIELDS and RDB$RELATIONS. The latter holds views
and tables.

Here are some examples on getting the info:
http://www.fbtalk.net/viewtopic.php?id=16

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com