Friday, July 27, 2007

Maximum for objects in sql server

Here are some maximum number of different objects in sql server.
  1. maximum number of character in table name-128
  2. maximum number of character in column name-128
  3. maximum number of table columns per select statement -4096
  4. maximum number of table columns per table-1024
  5. maximum number of foreign key reference per table-253
  6. maximum number of column per index-16
  7. maximum number parameters in stored procedure -1024
  8. maximum number of columns in view-128


Post a Comment

Your feedback is very important to me. Please provide your feedback via putting comments.

About Me
My Photo

Full Stack Developer,Blogger,Microsoft Mvp, Mentor, Life long learner, 10+ Years of Experience for JavaScript, web and Microsoft technologies. ASP.NET MVC,Web Forms,C#,AngularJs,Golang
Mvp profile
Subscribe to my blog

Enter your email address:

Follow us on facebook
Blog Archive
Total Pageviews