I am considering SQLServer as a database tool for a new development project.
What is the maximum number of columns I can put in a table?
Thanks in advance.
Bob
Printable View
I am considering SQLServer as a database tool for a new development project.
What is the maximum number of columns I can put in a table?
Thanks in advance.
Bob
from what i remember from my MCSD classes, you can have something like 256 (i think).
They bump that number up every SQL Server release. SQL 2000 is 1024. There's also a limit to how many total bytes a table row can have, though...
Although if you actually need 1024 columns you either have very specialised requirements in which case a standard RDBMS probably isn't the best solution, or you need to rethink your design.