Microsoft® SQL Server 2005 Unleashed

Chapter 19. Creating and Managing Tables

IN THIS CHAPTER

• What’s New in Creating and Managing Tables

• Creating Tables

• Defining Columns

• Defining Table Location

• Defining Table Constraints

• Modifying Tables

• Dropping Tables

• Partitioned Tables

• Creating Temporary Tables

Tables are logical constructs used for the storage and manipulation of data in databases. Tables contain columns, which describe data, and rows, which are instances of table data. Basic relational database design determines the table and column names as well as the distribution of columns within tables.

This chapter gives you the administrative knowledge you need to create tables and manage them within your enterprise. It focuses on the basic constructs for tables and the table-level features that ...