1 out of 2 rated this helpful - Rate this topic

Creating and Modifying Tables

SQL Server 2005

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

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions