On 5 Nov 2008, at 15:06, Leyne, Sean wrote:

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

So deleted tables stick around in rdb$relations?

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

Yes, we define temporary tables for doing various kinds of OLAP work.
We delete them, but AFAIK, the IDs do not get reused. Is this no
longer true?

Best regards,
-------------------------------------------------
Richard Wesley
Senior Software Developer

Tableau Software
t: 206.633.3400 x505
f: 206.633.3004
e: hawkfish@...

www.tableausoftware.com


----------





[Non-text portions of this message have been removed]