How many rows can we place in a single SQL Server table?
Asked
Active
Viewed 2.4k times
7
-
what about tables in a database. is there any limitations for tables. can i create any number of tables? – Surya sasidhar Feb 20 '10 at 05:59
2 Answers
9
There is no limit, except maybe for your hard drive size.
Have a look at Estimating the Size of a Table
and Maximum Capacity Specifications for SQL Server : Rows per table
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.
Adriaan Stander
- 162,879
- 31
- 289
- 284
-
5
-
ok thank you sir, i have another doubt, what about table is there any limit for creating table. – Surya sasidhar Feb 20 '10 at 05:50
-
1Only hardware limitation can restrict it. The sql-server (enterprise) does not restrict it. – HotTester Feb 20 '10 at 05:56
1
* System storage limits may preclude the limits specified here.
* A limit of storage means that the limit is dependent on the amount of storage available.
* A limit of statement means that the limit is dependent on the limit for the maximum length of a statement.
But if you want theoretical maximums then the following data maybe useful for you
Maximum number of rows in a non-partitioned table 4294967288 Maximum number of rows in a data partition 4294967288
You can check out IBM's reference page.
Prasanna Raghu
- 2,593
- 3
- 22
- 25