Justin
Reputation: 403
How many tables can a single SQL Server 2012 database hold?
I am working on C# application to create tables dynamically in a database. What is the maximum number of tables that one single database can hold or best practice for the number of tables to have in a database? The tables are not related to each other.
Note: Database is set to auto grow. There will be no max size for that database.
Upvotes: 2
Views: 1240
Answers (1)
Laerte
Reputation: 260
From MSDN:
Tables per database: Limited by number of objects in a database
Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647.
Upvotes: 4
Related Questions
- Is there a limit size for a SQL Server database?
- Is there a limit to the number of tables in a SQL Server database AND view?
- Define maximum table size or rows per table - SQL Server 2012
- Max number of tables (objects) in SQL Server editions (compact, express)
- Max number of tables in an Sql server database
- Number of Tables in Database
- At maximum how many rows can be in the SQL Server tables
- How many tables can I have in 1 Sql Azure Database
- How many tables are on an instance of SQL Server
- What's the maximum number of rows a single SQL Server table can store?