Reading Relational Tables
Learn how relational tables organize records and attributes, and how to read their schema and cells without assuming rows have a fixed order.
Rows, Columns, Cells, and
One subject, organized into records
A relational stores information about one kind of subject. In the Students below, each describes an attribute of a student, and each contains one student's record.
| student_id | name | birth_date |
|---|---|---|
| 1042 | Maya Chen | 2007-03-12 |
| 1043 | Luis Romero | 2006-11-28 |
Finding a and understanding the
A is the value where a and a meet. For example, the in Maya Chen's and the birth_date contains 2007-03-12.
The defines the 's columns—here, student_id, name, and birth_date. The rows are the records, and they can vary as data is added or removed; the describes the 's structure rather than its current set of students.
One important point: rows have no guaranteed order. If you need students listed in a particular order, request sorting explicitly instead of assuming the will always display them in the order shown.