Creating and Modifying Tables

The topics in this section provide the information to help you create and modify tables.

In This Section

• Creating and Modifying Table Basics
  Explains the basics of creating and modifying standard and temporary tables.

• Modifying Column Properties
  Provides information about and related topics to modifying column properties, such as data type, length, precision, scale, and nullability.

• Adding and Deleting Columns
  Provides information about and related topics to adding and deleting columns.

• Using Sparse Columns
  Describes the benefits of designating a column as sparse if it usually contains null values.

• Using Column Sets
  Describes how to use a column set to return all the sparse columns in the table as an XML column.

• Creating and Modifying PRIMARY KEY Constraints
  Provides information about and related topics to creating and modifying PRIMARY KEY constraints.

• Creating and Modifying FOREIGN KEY Constraints
  Provides information about and related topics to creating and modifying FOREIGN KEY constraints.

• Creating and Modifying UNIQUE Constraints
  Provides information about and related topics to creating and modifying UNIQUE constraints.

• Creating and Modifying CHECK Constraints
  Provides information about and related topics to creating and modifying CHECK constraints.

• Creating and Modifying DEFAULT Definitions
  Provides guidelines and links to creating and modifying defaults.

• Creating and Modifying Identifier Columns
  Provides information about and related topics to creating and modifying unique identifiers.

• Creating Compressed Tables and Indexes
  Provides information about storing tables and indexes in a compressed format.