Column Numbers in SQLSERVER

Question

Hi friends What is the maximum number of columns per table?

Pravin More · Answer

Hi Michell if you use simple table then its Max. Columns per table is 1024 but if ypu use wide table its 30000. Note:-wide table is a table that has defined a column set.Wide tables use sparse columns to increase the total of columns that a table can have to 30000. Thanks Pravin.

Dipal Choksi · Answer

For which version of SQL Server do you need this info? Here is the info for SQL Server 2008R2