Recently I had to check the maximum capacity of SQL server for our project.The real question was how many tables SQL server can have? After a fine search I could see that there is no maximum limit for the tables alone.It is considered as a database object and the maximum number of database objects supported is 2,147,483,647. The database objects includes tables, sps,indexes,views ,triggers etc…
I was searching for SQL server 2008 and here is the link with more details.
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Of course the tables are not created by hand, it is planned to be created through code.
No comments:
Post a Comment