Itqualityassurance
- Can a database table have too many columns?
- How many columns is too much in SQL?
- How many columns should you have in a table?
Can a database table have too many columns?
Column Count Limits
MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given table.
How many columns is too much in SQL?
For the columns in a table, there is a maximum limit of 1024 columns in a table. SQL Server does have a wide-table feature that allows a table to have up to 30,000 columns instead of 1024.
How many columns should you have in a table?
There is no precise guidance. A table could be as little as one column or as many as the max, 1024. However, in general, you'll probably see no more than 10-15 columns in a table in a well normalized database. But there are exceptions, so I wouldn't get too hung on it.
