> > >
> >
> > This is the real question....the first bit I knew..
> >
> > how do you loop this for each table to return a single
> result set of..
> >
> > TableName, Count Of Records....
>
> Loop through the RDB$_RELATIONS table and for each
> RDB$RELATION_NAME that has zero for the RDB$SYSTEM_FLAG
> field, do a count on that table. You will probably have to do
> this on the client side since you can't use variables for
> table and field names in a query in stored procedures.
>

Cheers - I had hoped there was an easier way via SP or script....

Gabhan