Maximum number of fields in a table

[gingette]

Hello there.

Is it better to have many fields in one table or to split the data between a number of tables and link them?

Thanks.

# gingette

 

[GaryPanic]

95% of the time thin and long tables against wide and short

there always exceptions to every rules - but if you work on this assumption- you should not make too many mistakes
as to number of fields I think its 250ish


regards

 

[neileg]

If you are tending to have a lot of fields, it indicates that you may have a design problem. If you don't know about normalisation, you should read up on this topic. Some types of application do produce lots of fields, but they are the exception.

The limit for a table is 255 fields.