Creating and Modifying Tables

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

In This Section

Topic Description

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.

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.