Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Creating and Modifying Tables

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.