Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition

Lesson 20. Creating and Manipulating Tables

In this lesson, you 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 (like Microsoft SQL Server Management Studio) to create and manage database tables interactively

Using T-SQL statements to ...