Table Types in SQL Server
Besides the standard user-defined tables, SQL Server provides the following types of tables in a database:-
- Partitioned tables:- Partitioned tables are those tables whose data is horizontally divided into units which may be placed across more than one filegroup in a database. Partitioning makes huge tables or indexes more easy to use.
- Temporary tables:- There are two types of temporary tables:-
Local :-Local temporary tables are visible only to their creators during the same connection to an instance.
Global :- Global temporary tables are visible to any user and any connection after they are created. - System tables:- SQL Server stores data that defines the configuration of the server and all its tables in a special tables known as system tables.
- Wide tables:- A wide table is a table that defined a column set. Wide tables use sparse columns to increase the total of columns that a table can have to 30,000.