Ok, for a single table, to count the number of rows you issue:
select count(*) from mytable
But to count the number of rows in your entire database (do you really need to know this?), you first need to determine the tables, and then issue the same select statement above.
To find the names of tables in a database is usually vendor specific, eg. in oracle there are numerous ways to do it, but a common one is:
select * from cat
Also to keep in mind, depending what user you used to connect to the database, may affect which tables you have access to.
Also, in
JDBC, there is a method on the java.sql.Connection interface to retrieve the metadata for the database (getMetaData()), and in the java.sql.DatabaseMetaData interface
you should find some methods for retrieving the tables within the database.
So the pseudo code would be:
In case I have gone way off the mark, and you just need code for rows in 1 table:
[ March 05, 2004: Message edited by: James Swan ]