column

A named, typed field that every row of a database table has, such as name or price.

In more detail

Every row has a value for each column, possibly null. Selecting only the columns you need keeps queries fast, and renaming or dropping a column that running code still reads breaks that code.

Example

The migration demo splits a name column into first and last columns.

Related terms

Taught in

References