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 are Some Advantages of Using CTE in SQL Server ?

What is SQL Injection in SQL Server ?

How is Auditing Different From Change Data Capture in SQL Server?

What is the Difference Between a Local and a Global Temporary Tab ...

How is Sqlcmd Different from Osql ?