CHAPTER 4

image

Tables

Imagine buying a new computer. You bring home the box, full of excitement. You open the box—and it’s empty! You have a box, but it’s not much use, is it? Databases are exactly the same. If you have a database without tables, it serves no purpose. Tables are the data containers. Everything you might want to store in a database—customer information, order details, your comic collection—has to go into a table. Virtually everything you build in your database will rely on data from tables.

I think it’s pretty clear that tables are quite important, so we’d better figure out how they work and how we can create them!

Table Basics

Tables ...

Get Introducing SQL Server 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.