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