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

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.



You May Interest

How is Auditing Different From Change Data Capture in SQL Server?

Getting List of All Stored Procedures in Database in MS SQL

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

Finding Server Default Language in MS SQL

Using CASE WHEN in MS SQL