How many rows can we place in a single SQL Server table?
+4
A:
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.
astander
2010-02-20 05:28:19
If it's SQL Express, up to 4GB data file.
o.k.w
2010-02-20 05:47:34
ok thank you sir, i have another doubt, what about table is there any limit for creating table.
Surya sasidhar
2010-02-20 05:50:52
Only hardware limitation can restrict it. The sql-server (enterprise) does not restrict it.
HotTester
2010-02-20 05:56:10
A:
* 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.
Saeros
2010-02-20 05:39:08