O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

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

HOUR 4. SQL Server Tables

After you have created a database, you are ready to add other objects to it. Generally, the first objects that you add to a database are the tables that it contains. In this hour you’ll learn:

How to create SQL Server tables

How to create constraints

How to work with identity columns

How to work with computed columns

How to work with user-defined data types

How to add and modify indexes

Creating SQL Server Tables

Tables are made up of rows and columns. We refer to columns as fields. Each field has a unique name and contains a specific piece of information about the row. Each table in a SQL Server database must have a unique name.

To create a table, follow these steps:

1. Within Management Studio, right-click ...

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