Subject SELECT COUNT(*) FROM :PARAMTABLE
Author Tanz Anthrox
I want to get the database statistics. I have 20 Tables and I want to get the record counts of tables
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?

Regards,

[Non-text portions of this message have been removed]