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

178 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 the Merge Statement in SQL Server ?

When Will You Use SQLDiag Tool ?

What are the Events On Default Trace in SQL Server ?

Disabling All Constants in a Table in MS SQL

What is Resource Governor in SQL Server ?