Sams Teach Yourself Microsoft

Lesson 20. Creating and Manipulating Tables

In this lesson, you’ll learn the basics of table creation, alteration, and deletion.

Creating Tables

T-SQL statements are not used just for table data manipulation. Indeed, T-SQL can be used to perform all database and table operations, including the creation and manipulation of tables themselves.

There are generally two ways to create database tables:

• Using an administration tool (such as one of the tools discussed in Lesson 2, “Introducing SQL Server”) to create and manage database tables interactively

• Using T-SQL statements to manipulate tables directly

To create tables programmatically, you use the CREATE TABLE SQL statement. It is worth noting that when you ...