Home > IT Answers > SQL Server > Column extention
Ctc123
20 pts.
 Column extention
SQL Server database design and modeling, SQL Server development
Hi I want to expand the number of columns that sql would permit me to creat. How do I start? any suggestions? example: 1032 maximun column limit I want in the area of upper 5000 ramge for a table. someone help thanks

Software/Hardware used:
ASKED: October 15, 2008  6:05 AM
UPDATED: October 15, 2008  12:38 PM
RELATED QUESTIONS
Answer Wiki:
SQL Server has a hard limit of 1024 columns per table as shown on this <a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx">web page</a>. It is not adjustable. If you have a table which is that wide you may need to look at making the table narrower. Having a table that wide usually isn't required.
Last Wiki Answer Submitted:  October 15, 2008  6:51 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.