Hi,

select rdb$relation_name from rdb$relations
where rdb$system_flag=0

lists all user defined tables.

If you want more (field) details, you could take a look at
Lorenzo Alberton's page which contains a lot of examples:

http://www.alberton.info/firebird_sql_meta_info.html

Kind regards,
Bert