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

229 Reads Ms Sql

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.

Ms Sql

You May Interest

What are the Various Limitations of the Views in SQL Server ?

What is CHECKPOINT Process in the SQL Server ?

What are the Different Recovery Models Inside SQL Server ?

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

What is a Covered Index in SQL Server ?