Subject RE: [firebird-support] Re: Number of tables in database
Author Dean Harding
> > Milan Babuskov wrote:
> > >
> > >> Ivan, care to explain why 32.000 is the limit?
> > >
> > > Nevermind, I just tried creating 40.000 tables and it failed.
> >
> > Maybe because RDB$RELATION_ID is a signed smallint and the engine
> > doesn't work with negative IDs :-)
>
> So, why is it signed, I wonder...? :-)

Because there are no unsigned integer types in Firebird SQL, maybe?

Dean.