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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
