How many tables a database can hold?

Depends on the database, and the version of it.

for your information remember this valuable points


<pre lang="vb">SQLServer Strengths
    * One instance can maintain 32,767 databases
    * One database can contain 2 billion tables
    * One table can support up to 1024 columns
    * Single table supports unlimited data (or) unlimited rows up to hard-disk capacity</pre>