Subject Re: [firebird-support] Maximum fields per table
Author Thomas Steinmaurer
> Is there a maximum number of fields per table? (I looked in Borrie's
> FB book but the limits does not mention this). If so, and its
> smallish, does it change for FB 2.x?

It depends on the used datatypes, because the max record size is ~64K.

That said, you will hit the limit pretty fast with e.g. two
VARCHAR(32000) and some additional fields. You won't hit the limit that
fast with only Integer fields.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: