Subject RE: [ib-support] Max metadata changes allowed
Author Thomas Steinmaurer

> > You can perform a total of 254 metadata changes on a database object. As
> > soon as one object reaches this magic total, you won't be able to connect
> > to the database before backing up and restoring. This will restore the
> > change counts on all objects to zero.
> How can I see the actual counter for the database objects ?

The counter is related to relations, and for each relation
the metadata change counter is stored within the system
table rdb$relations.


select rdb$relation_name, rdb$format from rdb$relations

Where rdb$format is the actual counter.

Thomas Steinmaurer