This topic has not yet been rated - Rate this topic

Creating and Modifying Tables

SQL Server 2008 R2

Other Versions

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ