Richard,

> How do I tell when I have run out of new table IDs? And if I have,
> will a backup and restore fix the problem?

By "table ID" are you referring to the system's ID for the Table?

If so, then:
- you can execute the following SQL to find out the last ID value:
SELECT MAX( rdb$relation_id) FROM rdb$relations
- if you have reached the limit,
a backup/restore will not solve the problem.

I don't know where the next Table ID value is stored (I thought a system
defined Generator, but can't find it). A backup/restore will not reset
the ID, and trying to manually set the ID will get you into other
problems.

FYI: you would have had to defined ~32,700 tables before you would run
into this problem.


Sean