| Subject | Re: [firebird-support] Row count for all tables |
|---|---|
| Author | Ann Harrison |
| Post date | 2011-03-29T15:34:50Z |
On Tue, Mar 29, 2011 at 10:39 AM, Scott <chucky1440@...> wrote:
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,
Ann
> Hello,Use an execute block and a query on RDB$RELATIONS to get the
>
> Is there a easy way to get the row count for all tables?
>
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,
Ann