views:

551

answers:

2

Is there a way to calculate the maximum number of columns? Thanks.

A: 

I would say 42, but the real answer is 4096
RTFM

Notice this number is not absolute (read the link I gave you).

Itay Moav
A: 

Right, but isn't that dependent on other variables (column name, data type, etc)? I'm wondering how to effectively calculate the max with those in mind. Thanks!

This is not a forum, you don't ask using the answer, but rather you add a comment to my answer. You better delete this, as it might get voted down.As for your question, in the link I gave you it says exactly the size limitation of columns in a table, you can then calculate this easily combining [show columns] and some math.
Itay Moav