O'Reilly logo

Sams Teach Yourself Microsoft by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required