What is the maximum number of tables in a database?

How many tables can a database have?

You can create up to 2,147,483,647 tables in a database, with up to 1024 columns in each table. When you design a database table, the properties that are assigned to the table and the columns within the table will control the allowed data types and data ranges that the table accepts.

Can you have too many tables in a database?

Having excess tables does mean memory & hard drive space that could be regained & used for other things. Keep in mind that denormalizing your tables increases the risk of bad data because you are getting rid of referencial integrity.

What is the maximum size of a database?

SQL Server Database Engine objectMaximum values for SQL Server (64-bit)Database size524,272 terabytesDatabases per instance of SQL Server32,767Filegroups per database32,767Filegroups per database for memory-optimized data1

What is the maximum number of tables in a query?

With SQL 6.5 and earlier the limit is 16 - regardless of which "version" of SQL you are running - i.e. Enterprise Edition allows no more than standard. With SQL 7.0 the limit is 256.