Sorry for my ignorance. But isnt this counter suppose to be reset with a
backup and restore ?
The reason is I have a counter on a table where no change was made after a
backup and restore was done

Note this is interbase 5.6


Thanks

Johannes


At 08:17 19/03/2003 +0100, you wrote:

>Marco,
>
> > > 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.
>
>Try:
>
>select rdb$relation_name, rdb$format from rdb$relations
>
>
>Where rdb$format is the actual counter.
>
>
>HTH,
>Thomas Steinmaurer
>http://www.iblogmanager.com
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/