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

33 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

Getting Character Count in MS SQL

Differences Between Stored Procedure and Function in MS SQL

What is Change Data Capture in SQL Server ?

Changing Column Name of MS SQL Table with Query

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