Home > IT Answers > SQL Server > SQL Server 2000 Database Table Limit?
Xarly
25 pts.
 SQL Server 2000 Database Table Limit?
SQL Limits, SQL Server 2000, SQL Server database, SQL Server tables
Is there a limit to how many tables a single database can hold in SQL 2000?

Software/Hardware used:
ASKED: May 6, 2009  8:18 PM
UPDATED: May 7, 2009  1:28 AM
RELATED QUESTIONS
Answer Wiki:
There is not really a limit to the actual number of tables rather there is a limit to the number of total database objects, which includ all tables, views, stored procedures, triggers, rules, defaults, constraints, etc... When you take the sum of all of those elements, they cannot exceed 2,147,483,647. I think you would want to ensure you have the capacity, memory, hard drive space, etc. Interesting question though... <a href="http://www.fontanatech.net">FontanaTech</a>
Last Wiki Answer Submitted:  May 7, 2009  1:20 am  by  Fontanatech   265 pts.
All Answer Wiki Contributors:  Fontanatech   265 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I think you can have 2,147,483,647 objects, but I couldn’t find any oficial source to confirm it.

carlosdl
 63,535 pts.
 

Thanks Carlos. I looked myself, but couldn’t find anything in a quick search either. If what you say is true, that is very helpful. Thanks.

Chris

Xarly
 25 pts.
 
Fontanatech
 265 pts.
 

Excellent, the exact source I was looking for. Feel kind of stupid not thinking to look directly into MSDN.

Well, I think 2+ billion objects is suffice for my project.

Thanks for your time guys.

Regards,
Chris

Xarly
 25 pts.