Subject Re: table & table's record
Author jameschua1021
Hi Adam,

Thanks a lot.

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