O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Chapter 11. Creating Tables and Views

Tables are the foundation of a relational database. Every database consists of one or more tables that store the data, or information in the database. The first part of this chapter covers the fundamentals of tables and demonstrates how to create, modify, and drop tables. Before you begin to create tables, you’ll need to make some decisions about the type of data that will be stored in each table, the structure of each table (including the data type of each column), and the relationships of the different tables to one another. We will cover the structure of tables in this chapter, while table relationships are covered in Chapter 13 ...

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