I quite like Ivan Prenosils solution for approximate counts of tables with primary keys (at least if some of the tables are huge):

www.firebirdfaq.org/faq5/

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Milan Babuskov
Sent: 7. desember 2009 17:17
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] count records of all tables

Dimitry Sibiryakov wrote:

>> It's not bad when you get a completely new database to work with and
>> want to get some overview about which tables already have records in them.
>
> `gstat -r` will give much more useful information

A little bit too much for this task, plus you need to be SYSDBA or owner
of database.

Useful command though. Thanks for the tip.

Regards,

--
Milan Babuskov