SQLite Forum

How to get the last row_id in a table without inserting anything
Login
Hi,
Im trying to get the last row_id from a table but without inserting anything in it.
( sqlite3_last_insert_rowid(db); this doesn't work if I do not insert any new row) 
I just need to know which is the max row id in the table so I can iterate from that point to row id 1.
thanks a lot
Fede