I use FB 1.5 embedded in thousands of installations. It has worked very well--and I have a class structure (in Delphi) that I use to update the database. I have 94 updates that occur from the original installed database. Again, this has worked very well.

I know at some point I am going to have to be checking the database tables to see how many alters I can make to a table before backing up and restring the database (something that will have to be fully automatic for my customer base).

What is the SQL to find out how many updates are remaining per table? And does it change from 1.5 to 2.x or 3.x? (Which I could move to at the same time, but just never had a need to get there--my DB needs are fairly light).

Thank you,

Ed Dressel