Subject Re: [firebird-support] Row count for all tables
Author Ann Harrison
On Tue, Mar 29, 2011 at 10:39 AM, Scott <chucky1440@...> wrote:
> Hello,
>   Is there a easy way to get the row count for all tables?

Use an execute block and a query on RDB$RELATIONS to get the
table names. Exclude those with a non-zero system flag and those
with a non-null view blr. Use the name to build a select count(*)
query on each table.

Or use gstat, I guess.

Good luck,