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

206 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

How to Optimize Stored Procedure in SQL Server ?

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

What is SQL Profiler ?

Disabling a Specified Trigger in MS SQL Server

How to Learn MS SQL Server Version