| Subject | Re: [firebird-support] SELECT COUNT(*) FROM :PARAMTABLE |
|---|---|
| Author | dade2000 |
| Post date | 2004-02-12T10:33:20Z |
Tanz Anthrox wrote:
> I want to get the database statistics. I have 20 Tables and I want to get the record counts of tablesexecute statement 'SELECT COUNT(*) FROM ' || PARAMTABLE into :TheCount
>
> I tried to get the tablenames from rdb$xxxxxx but I couldnot find. Is there a way to do this?
>
>
>
> And,
>
>
>
> SELECT COUNT(*) FROM :PARAMTABLE
>
>
>
> This Query is not working. Is there a way to write a SP for this?