Tables in SQL Server
Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.
Types of Tables are listed below:
Table | Description |
---|---|
Partitioned Tables | Partitioned tables are tables whose data is horizontally divided into units which may be spread across more than one filegroup in a database. |
Temporary Tables | Temporary tables are stored in tempdb. There are two types of temporary tables: local and global. They differ from each other in their names, their visibility, and their availability.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. |
System Tables | System tables in SQL Server stores the data that defines the configuration of the server and all its tables in a special set of tables. Users cannot directly query or update the system tables. The information in the system tables is made available through the system views. |
Wide Tables | A wide table has defined a column set, which is an untyped XML representation that combines all the sparse columns of a table into a structured output. Wide tables use sparse columns to increase the total of columns that a table can have to 30,000. Sparse columns are ordinary columns that have an optimized storage for null values. |
SQL Server Connection String Formats
posted on 2019-08-27 05:53:53 - SQL Server Tutorials