What is the maximum size limit for a single table in SQL?

The first table shows that for all microsoft® SQL server& #8482; 2000 versions are the same
Maximum capacity. The second and third tables describe different versions of SQL Server 2000 and the operating system
Capacity.

The following table describes what is defined in the Microsoft SQL Server database, or in the Transact-SQL statement
The maximum value (number or size) of the various objects referenced in the The following table does not contain microsoft® SQL Server
2000& #8482; windows® CE version.

Maximum value (quantity or size)
Object SQL Server 7.0 SQL Server 2000
Batch size 65,536 * network packet size 1 65,536 * network packet size 1
Number of bytes per short string column 8,000 8,000
Number of bytes per text, ntext, or image column 2 GB-2 2 GB-2
Number of bytes per GROUP by, ORDER by 8,060
Number of bytes in each index 900 9002
Number of bytes per foreign key 900 900
Number of bytes per primary key 900 900
Number of bytes per line 8,060 8,060
Number of bytes in the stored procedure source text the smaller of the batch size or the smaller of the size of the bulk MB batch
or a MB
Number of clustered indexes per data table 1 1
The number of columns in GROUP by and ORDER by is limited by the number of bytes
Number of columns or expressions in the GROUP by with CUBE or with ROLLUP statement 10
Number of columns per index 16 16
Number of columns per foreign key 16 16
Number of columns per primary key 16 16
Number of columns per underlying data table 1,024 1,024
Number of columns per SELECT statement 4,096 4,096
Number of columns per insert statement 1,024 1,024
Number of connections per client The maximum value of the configured connection has been configured Max
Database size 1,048,516 TB3 1,048,516 TB3
Number of databases per instance of SQL Server 32,767 32,767
Number of filegroups per database 256 256
Number of files per database 32,767 32,767
File size (data) TB (TB)
File size (log) 4 TB
Foreign key table references for each data table 253 253
Identifier length (in characters counted) 128 128
The number of instances per computer is 16
String length containing the SQL statement (batch size) 65,536 * network packet size 1 65,53
6 * Network packet size 1
Number of locks per connection maximum number of locks per server Max locks per server
Number of locks per SQL Server instance 2,147,483,647 (Static)
SQL Server 40% Memory (dynamic) 2,147,483,647 (static)
SQL Server 40% Memory (dynamic)
Number of nested stored procedure layers 32 32
Nested subqueries 32 32
Number of nested trigger layers 32 32
Number of nonclustered indexes per data table 249 249
Number of simultaneous open objects in an instance of SQL Server 4 2,147,483,647 (or available memory) 2,147,4
83,647 (or available memory)
Number of objects in each database 2,147,483,6474 2,147,483,6474
Number of parameters per stored procedure 1,024 1,024
Number of REFERENCE per data table 253 253
The number of rows per data table is limited by available storage resources
The number of data tables per database is limited by the number of objects in the database 4 limited by the number of objects in the database 4
Number of data tables per SELECT statement 256 256
The number of triggers per data table is limited by the number of objects in the database 4 limited by the number of objects in the database 4
UNIQUE index or number of constraints per data table 249 nonclustered indexes and one clustered index
249 Nonclustered indexes and one clustered index


1 The network packet size is the size of the tabular Data Scheme (TDS) packet that is used for the application process
Communication between the sequential and relational database engines. The default packet size is 4 KB, by the network packet Si
Ze configuration option control.

2 in SQL Server 2000, the maximum number of bytes for any key cannot exceed 900. can use variable length
A column of degrees defines the key, as long as the row in which the data exceeds 900 bytes is inserted, the maximum size can be
More than 900. For more information, see Maximum values for index keys.

3 When you use SQL Server Desktop Engine or the Microsoft data engine (MSD
E) 1.0, the size of the database cannot exceed 2 GB.

4 database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, default values, and
Constraints. The total number of objects in a database must not exceed 2,147,483,647.


Description SQL Server 2000 Chinese version does not support the English version of NT 4.0 Enterprise Edition.

Maximum number of processors supported by version of SQL Server 2000
The following table lists each SQL Server 2000 version of the database engine in a symmetric multi-processing (SMP) computer
The number of processors that can be supported on the




Operating system Enterprise Edition Standard Edition Personal Edition developer Desktop Engine SQL Server CE Enterprise Evaluation Edition
Microsoft windows® DataCenter 32 4 2 32 2 N/A 32
Windows $ advanced Server 8 4 2 8 2 N/a 8
Windows Server 4 4 2 4 2 N/a 4
Windows Professional 2 2 2 N/a 2
Microsoft Windows nt® 4.0 Server Enterprise Edition 8 8 2 8 2 N/a 8
Windows NT 4.0 Server 4 4 2 4 2 N/a 4
Windows NT 4.0 Workstation 2 2 2 N/a 2
Microsoft Windows 98 N/a 1 use Desktop Engine 1 N/A
Microsoft Windows CE N/a 1 N/a


Maximum amount of physical memory supported by SQL Server 2000 version
The following table lists the maximum amount of physical memory or RAM that the data engine can support in each SQL Server version 2000.

Operating system Enterprise Edition Standard Edition Personal Edition developer Desktop Engine SQL Server CE Enterprise Evaluation Edition
Windows DataCenter 2 GB 2 GB 2 GB GB
Windows $ advanced Server 8 GB 2 GB 2 GB 8 GB 2 GB N/a 8 GB
Windows 4 GB 2 GB 2 GB 4 GB 2 GB N/a 4 GB
Windows Professional 2 GB 2 GB 2 GB N/a 2 GB
Windows NT 4.0 Server Enterprise Edition 3 GB 2 GB 2 GB 3 GB 2 GB N/a 3 GB
Windows NT 4.0 Server 2 GB 2 GB 2 GB 2 GB 2 GB N/a 2 GB
Windows NT 4.0 Workstation 2 GB 2 GB 2 GB N/a 2 GB
---------------------------------------------------------------

Number of rows limit =32 TB *32,767/bytes per line
If your hard drive is less than the size of a TB *32,767, it is hard disk capacity/number of bytes per line

What is the maximum size limit for a single table in SQL?