Understanding Tables

The topics in this section provide the information to help you understand tables in SQL Server.

In This Section

  • Table Basics
    Explains basic table concepts. These include columns, rows, and data types.

  • Data Integrity Basics
    Introduces the mechanisms for guaranteeing data integrity in tables. These include null values, constraints, rules, and defaults.

  • Special Table Types
    Explains partitioned tables, temporary tables, and system tables.