Chapter 5. Designing Tables
After completing this chapter, you will be able to
Create and manage schemas
Select appropriate data types
Define appropriate properties for table columns
Create tables
Understand the new FILESTREAM, SPATIAL, and DATE/TIME data types
Create computed columns
Define constraints to enforce data integrity
Configure data storage options for compression and sparse rows/columns
The heart of any database and the purpose of any database platform is to store and manage data. Without tables, it is impossible to store or manage data. In this chapter you will learn how to define tables to store your data. You will also learn how to define the data types, properties, and constraints necessary to provide structure to the data in a way that ...
Get Microsoft® SQL Server® 2008 Step by Step 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.
