The size of the table is going to be limited by the amount of available memory you have. You can create a table with up to 2^31 (2.1 billion) rows in it, if all you are storing is integers in one column, this is going to take about 8 Gigs of RAM. I just created a table with over 1,000,000 rows, and it worked fine.
Hope this helps-
Dustin