Geek Answers Handbook

What is the maximum number of rows a single SQL Server table can store?

How many rows can be placed in a single SQL Server table?

+7
sql-server
source share
2 answers

There are no restrictions, except, perhaps, the size of the hard drive.

See Table Size Estimation

and Maximum Capacity for SQL Server: Rows in a Table

Tables per database: limited by the number of objects in the database

Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, default values, and restrictions. the sum of the number of all objects in the database cannot exceed 2,147,483,647.

+9
source share
* 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 need theoretical highs, then the following data may be useful to you.

The maximum number of rows in the table without sectioning 4294967288 The maximum number of rows in the data section 4294967288

You can check the IBM help page .

+1
source share

More articles:


All Articles