What is the Maximum Number of Columns a Table in SQL Server ?

The maximum columns per table are 1024 in SQL Server..

If a table is a wide table which means it contains a SPARSE column, the columns per table is 30,000.



You May Interest

What is a ROLLUP Clause in SQL Server ?

What is Extensible Key Management in SQL Server ?

What is Deadlock in SQL Server ?

What are Sparse Columns in SQL Server ?

Getting Rows in a Table in Random Order in MS SQL