C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

k prabhakar va... (1)

Last 7 Days

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

(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

dotNet Slackers BizTalk Adaptors Web Design

accuconference