> 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).

It's the field RDB$RELATIONS.RDB$FORMAT.

AFAIR the limit is 255 and didn't change in V2.x.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!