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

42 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 is an Online Rebuilding of Indexes in SQL Server ?

What is Deadlock in SQL Server ?

List of Table Columns Used in Any View in MS SQL

What are the Authentication Modes in SQL Server ?

Getting Character Count in MS SQL