--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> ...
> > select 'SELECT cast('''||rtrim(rdb$relation_name)||''' as
> > varchar(100)), count(*) FROM '||rtrim(rdb$relation_name)||' UNION '
> ...
> ...
>
> If I hit my databases with this statement I'd have to take a holiday
> :-)
> needless to say I'm not tied mentally to how many records are in any
> particular table
> Do you put this in your client app?
> Alan

Alan,

This was actually a reply to the "Count records in tables" thread,
but I posted this rather then replying but noticed to late!

Gabhan was asking how he could get the row count for all tables in the
database without looping over rdb$relations.

Sorry for the confusion.

Best Regards
Thomas