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.

Search This Blog
About Me
My Photo

Full Stack Developer, Blogger, Microsoft Mvp, Mentor, Lifelong learner, 12+ Years of Experience for JavaScript, web and Microsoft technologies. ASP.NET MVC/Core, C#, Angular,Vue.js and node.js
Subscribe to my blog


My You tube channel- Please Subscribe
Youtube Video Playlist
My Mvp Profile
Follow us on facebook
Blog Archive
Total Pageviews