Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ajoo
Starting Member
12 Posts |
 Posted - 2013-12-03 : 11:22:29
|
| Hi, Just want to know if there is a limit on the number of tables to a database. that is the number of tables that may be created in a database.Thanks. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-12-03 : 11:39:42
|
general rule of thumb: if you need to ask about a limit in sql server then you have a bad design.from books online:quote:
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
Be One with the OptimizerTG |
 |
|
|
Ajoo
Starting Member
12 Posts |
Posted - 2013-12-03 : 11:56:55
|
| Wow ! thanks !! |
|
|
|
|
|
|
Limit on tables in a database.