--- In firebird-support@yahoogroups.com, "jameschua1021"
<cai.haibin@g...> wrote:

> Is there a fast way so that i could see a list of all my tables and
> it's number of records.
>
> Apinot

Hello Apinot,

The table names are all in RDB$RELATIONS.
There is no "fast" way to count every record, because the total will
depend on which transaction you are in.

You can certainly write a Stored Procedure to cycle through every table
within RDB$RELATIONS and run a select count(*) from ..., similar to the
generator one I wrote for you the other week.

Adam