max number fields in a table?

[jgoodman00]

What is the theoretical maximum number of fields which a table can have, & what is the maximum people have seen in a normalised database?? James Goodman
j.goodman00@btinternet.com

 

[AshleyRickards]

I believe it's 1,024 per table. Ashley L Rickards
SQL DBA

 

[RickCole]

From SQL Server 7.0 upwards the max number of field per table is indeed 1024.

The other restriction you should bear in mind is that the max row size per table is 8060 bytes (not counting the text or image datatypes).

So unless you have very short fields I would think you would end up being restricted by the row size rather then the number of fields.

Personally (but it does depend on the data)I think if I had any table with over a 100 fields I would take a serious look at splitting it down.

Rick.