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 the Difference Between UNION and UNION ALL in SQL Server ...

What is the Use of DBCC Commands in SQL Server ?

What is Log Shipping in SQL Server ?

Using Trim Function in MS SQL

MS SQL Restoring a Database With a Query