Chapter 4. Creating Tables and Other Objects

In this chapter, you will learn how to create various objects within the SQL Server database. Primarily, we'll focus on creating tables and objects such as indexes and constraints that are closely related to tables. To get the most out of this chapter, you should follow along using SQL Server Management Studio and the instance of SQL Server you installed in Chapter 2.

Navigating the Object Explorer Tree

You can find SQL Server Management Studio in the Microsoft SQL Server 2008 folder of the Start menu. When this application launches, it will ask you for the server you want to connect to. If you need help, please read the "Connecting to SQL Server" section in Chapter 3.

Once you are connected to the SQL ...

Get Beginning SQL Server 2008 Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.