Subject Re: Max number of fields
Author Adam
--- In firebird-support@yahoogroups.com, "rainingmanca"
<rainingmanca@y...> wrote:
> Hi,
>
> I have to create table with large # of fields.
>
> I would like to know what is the maximum number of fields I can create
> in firebird database?
>
> Thanks
>
> Igor

Igor,

What is the ballpark for "large". I am not exactly sure if there is a
specific limit, but I know each row is 32k or therabouts, so depending
on your field definitions, this limit may be more significant.

http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;FAQS;NAME='System+Limits'

To be honest, I have not seen many tables with large numbers of fields
that are normalised correctly. Perhaps if you provide an example of
what you are trying to do, a better solution can be found.

Adam