Is there any limitation in Table Numbers in Microsoft SQL Server database?

Depending on SQL server edition and environment, there will be limitation. Please refer to the following URL for maximum capacity specifications for different SQL Server versions:

https://msdn.microsoft.com/en-us/library/ms143432.aspx