Tutorials
Resources
Forum
Communities
Interview
Jobs
Projects
Offshore Development
Silverlight Tutorials
|
Mentor
|
Code Converter
|
Articles
|
Code Factory
|
Computer Jokes
|
Members
|
Peer Appraisal
|
IT Companies
|
Bookmarks
|
Revenue Sharing
|
Prizes & Awards
My Profile
Sign In
Register
AdSense Revenue
Active Members
Today
k prabhakar va...
(1)
Last 7 Days
Deepika Harida...
(1149)
Pradeep Y
(997)
amarababu nara...
(961)
more...
New Feature:
Community Sites
:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
Some limitations of SQL Server table
Posted Date: 10 May 2007 Resource Type:
Articles
Category:
Databases
Posted By:
RamarajSundaram
Member Level:
Diamond
Rating:
Points
: 5
Introduction
The ultimate aim of this article is to describe the some limitations of Sql server table.
The following are some limitations of Sql server table.
The maximum number of columns per base table is 1024.
The maximum number of columns per index is 16.
The maximum number of columns per SELECT statement is 4096.
The maximum number of foreign key table references per table is 253.
The maximum number of parameters per stored procedure is 1024.
The maximum number of characters allowed for a table name is 128.
The maximum number of characters allowed for a column name 128.
The maximum number of columns in the view is 250.
Summary
This article will be very useful for future reference.
Responses
Author:
Mahesh H Shivaswamy
09 Jun 2008
Member Level:
Silver
Points
: 0
Thanks 4 usefull inforamtion.
Feedbacks
Popular Tags
What are tags ?
Search Tags
Sign In
(No tags found.)
Post Feedback
This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must
Sign In
to post a response.
Next Resource:
Purpose of Views and Restriction of View in Sql server
Previous Resource:
Exception Handling in SQL Server
Return to Discussion Resource Index
Post New Resource
Category:
Databases
Post resources and
earn money
!
Related Resources
Implementing Table Variables in SQL Server
SQL queries most asked in .NET/SQL Server job interviews
Find all SQL logins in a server
Useful Stored procedures in SQL Server Part 2
Selecting data by using LIKE with ESCAPE
dotNet Slackers
BizTalk Adaptors
Web Design
accuconference
Contact Us
Privacy Policy
Terms Of Use