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 Partial Cache Mode in SSIS ?

What are the Different Recovery Models Inside SQL Server ?

How to Restart SQL Server in Single-User Mode ?

Differences Between Stored Procedure and Function in MS SQL

What is Extensible Key Management in SQL Server ?