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

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.5 SQL 7.0 
Database size 1 TB 1,048,516 TB
File size 32 GB 32 TB
Files per database 32 32768

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.