Skip navigation

What is the maximum number of rows in a SQL table? What other size limitations are there? - 29 Nov 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


TAGS: SQL
Hide comments

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.
Publish