A table is the everyday, practical name for a relation — the actual structure you create with CREATE TABLE, made of rows and columns.
Why This Matters
- This chapter is short on purpose: Table and Relation are the same idea from two different angles — Relation is the theory, Table is the thing you actually build.
- Every remaining chapter in this course will just say "table", because that's what you'll be doing.
Core Concept
- A Table is the concrete, named structure — rows and columns — that a relational database actually stores, and that SQL's CREATE TABLE statement defines.
- Every table has a fixed set of column names and types (its schema), and holds zero or more rows at any given time (its instance/data).
Deep Dive
- A table's name and column definitions are decided once, when it's created — changing them later (adding a column, renaming one) is a deliberate, separate operation you'll meet in the DDL section of this course, not something that happens casually.
- The rows inside a table, by contrast, change constantly — insert, update, delete — without touching the table's structure at all. Keeping these two ideas separate (structure vs. content) is exactly the Schema vs. Instance distinction a few chapters from now.
Common Mistakes
Treating a table's structure and its data as if changing one always requires changing the other.
Why: A table's column definitions and its actual rows are two independent things that change at completely different speeds and for different reasons.
Fix: Ask separately: "does this change the table's structure?" vs. "does this change the table's data?" — they're almost never the same operation.
Interview Questions
What's the difference between a table and a relation?
Nothing conceptually — "table" is the everyday, practical term and "relation" is the formal, mathematical term for the exact same structure: rows sharing the same columns.
Chapter Summary
A table is a relation in practice — the named, structured thing you create and query. From here on, this course uses "table" by default, since that's the term you'll actually use day to day.