locked
table limits within a single database RRS feed

  • Question

  • What is the limit to the number of tables that can be within a single database?

     

    thanks..

    Friday, August 13, 2010 1:16 PM

Answers

  • What is the limit to the number of tables that can be within a single database?

     

    thanks..


    There isn't a single answet, and it depends on the data provider, but in SQL Server, for example, the total number of objects (including tables, views, triggers, etc.) is over 2 billion. You'll give out long before it does, lol.
    Rebecca M. Riordan
    • Marked as answer by MSUTech Friday, August 13, 2010 1:38 PM
    Friday, August 13, 2010 1:23 PM

All replies

  • What is the limit to the number of tables that can be within a single database?

     

    thanks..


    There isn't a single answet, and it depends on the data provider, but in SQL Server, for example, the total number of objects (including tables, views, triggers, etc.) is over 2 billion. You'll give out long before it does, lol.
    Rebecca M. Riordan
    • Marked as answer by MSUTech Friday, August 13, 2010 1:38 PM
    Friday, August 13, 2010 1:23 PM
  • ha ha....

    thanks!

    Friday, August 13, 2010 1:38 PM
  • HI,

    The InnoDB storage engine maintains InnoDB tables within a tablespace that can be ... If you need a MyISAM table that is larger than the default limit and your ... tables. myisampack also can merge multiple tables into a single table. ... I was trying to import some huge database dump,

     

     

     

     

    __________________________________________________________________

    Want to get-on Google's first page and loads of traffic to your website? Hire a SEO Specialist from Ocean Groups  [url=http://oceangroups.org/] seo pecialist [/url]

    Tuesday, August 17, 2010 10:05 AM