|Subject||Re: [firebird-support] # Updates a table has remaining|
> 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.It's the field RDB$RELATIONS.RDB$FORMAT.
> 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).
AFAIR the limit is 255 and didn't change in V2.x.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server