Did SQL have limit on numbers of table ?

Answer 1

there is no limit on number of tables. But of memory size one database can handle 64gb of memory.

Answer 2

depends on the version of SQL Server. Normally there is no limit.

Answer 3

untill the hd is full

Answer 4

nope