Max number of tables and max no of rows in a Table in SQL Server

Posted Date: 16 Jul 2012 Posted By:: Shovan Mukherjee Member Level: Silver Member Rank: 932 Points: 2 Responses: 4

Can anyone tell me please..What is the

1) Max number of tables possible you can create in a SQL Database?

and

2) Max number of rows you can insert into a SQL Server table(Assuming the data/.MDF file is big enough and auto growth option is specified and no Disk space constraint)?

Responses

#680594 Author: Ajatshatru Upadhyay Member Level: Gold Member Rank: 19 Date: 16/Jul/2012 Rating: Points: 2
Hi, There is no any limit for number of tables that a SQL database can hold. Also, there is a limit of 1024 columns in a SELECT statement in SQL SERVER. As far as maximum number of columns per table is concerned, I don't think Microsoft defined any. Hope it'll help you. Regards Ajatshatru

#680595 Author: bulli guruvu setty Member Level: Gold Member Rank: 335 Date: 16/Jul/2012 Rating: Points: 1
Hi Shovan Mukherjee, Please go through the below article,it will give you complete information about Maximum Capacity Specifications for SQL Server: http://msdn.microsoft.com/en-us/library/ms143432.aspx Thanks & Regards D.Bulli Guruvu Setty

#680600 Author: Alwyn Duraisingh Member Level: Gold Member Rank: 11 Date: 16/Jul/2012 Rating: Points: 4
If a Sql Server is installed in a Local desktop/ network, You can have as many tables in a database until your harddrive space limitation is reached. Also there is no limitation for the Rows, In my experience i have dealed with a table that has 70 GB of data. But if you would like to host your Sql Server in Web, then you need to think of the limitations, leading providers like godaddy is limiting the Sql Server database to 250 MB and in this case you cannot hold as many rows in a sql server table. Regards, Alwyn Duraisingh.M << Database Administrator >> Jesus saves! The rest of us better make backups...

#680602 Author: Paritosh Mohapatra Member Level: Diamond Member Rank: 6 Date: 16/Jul/2012 Rating: Points: 2
Max number of tables in the SQL Server database is limited to the number of objects in a database. Maximum number of rows per table depends upon the physical memory of the system. Thanks & Regards Paritosh Mohapatra Microsoft MVP (ASP.Net/IIS) DotNetSpider MVM

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Restore backupfile to MySQL
	Previous : How enable the Pagination in SSRS
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
Today

Last 7 Days

baskar (298)
Asheej T K (173)
Ultimaterengan (167)

more...

Awards & Gifts

Email subscription