Subject RE: [firebird-support] count records of all tables
Author Svein Erling Tysvær
I quite like Ivan Prenosils solution for approximate counts of tables with primary keys (at least if some of the tables are huge):


-----Original Message-----
From: [] On Behalf Of Milan Babuskov
Sent: 7. desember 2009 17:17
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.


Milan Babuskov