Column (Field)

A column is a single attribute in a database table, such as 'name' or 'age'. Every column has a fixed data type, and every row stores one value for each column.

SQL

Columns are sometimes called fields. They define the shape of a table: what kinds of information each record can hold and what type that information must be.

When you SELECT data, you choose which columns to return, and you can rename them in the output using an alias.

Examples

SQL

SELECT name, age FROM users;

Output:

name   age
-----  ---
Alice  30
Bob    22

Learn it in a lesson

See also

Back to the Dictionary