What is the maximum number of rows in a SQL table? What other size limitations are there? - 29 Nov 1999

Neil Pike

November 28, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. There is no maximum number. You can keep adding rows until the database runs out of space. As far as other maximums go :-

SQL 6.5SQL 7.0 
Database size 1 TB 1,048,516 TB
File size32 GB32 TB
Files per database3232768

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like