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

198 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 Difference Between Update Lock and Exclusive Lock in ...

What is Service Broker in SQL Server ?

What is the Merge Statement in SQL Server ?

What are Replication and Database Mirroring in SQL Server ?

How to Show Line Numbers in MS SQL Server ?