| Subject | Re: [firebird-support] Count records in tables | 
|---|---|
| Author | Martijn Tonies | 
| Post date | 2004-02-20T14:30:19Z | 
Hi,
FROM yourtablename
Loop this for each table.
Mind you, it can be -very- slow on large tables.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
            > Is there a way to return a count of the records in each table in afirebird
> database?SELECT COUNT(*)
FROM yourtablename
Loop this for each table.
Mind you, it can be -very- slow on large tables.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com