SQL Tables

Database objects that contain all the data in a database.

The number of objects allowed in a database (2,147,483,647)

1,024

The storage capacity of the server.

Disallow values or provide a default value if one is not specified. You can also assign a key constraint on the table that enforces uniqueness or defines a relationship between tables.

Row or page.

More rows to be stored on a page.

Partitioned tables are tables whose data is horizontally divided into units which may be spread across more than one filegroup in a database. Partitioning makes large tables or indexes more manageable by letting you access or manage subsets of data quickly and efficiently, while maintaining the integrity of the overall collection.

Up to 15,000 partitions

Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user, and they are deleted when the user disconnects from the instance of SQL Server.

Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server.

This is where SQL Server stores the data that defines the configuration of the server and all its tables. Users cannot directly query or update the system tables. The information in the system tables is made available through the system views.