# Column

> One kind of fact every row holds, like name or price, with a set type.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** Field, Database Column, Attribute

## Think of it like

Think of it like one box on a form, such as Name. Every form has it, and each person fills it in.

## Definition

A column is one kind of fact that every row in a table holds, like name or price. Each column has a name and a data type, such as text, number or date. The type stops wrong values, like a word in a price column. A column can also have rules, like NOT NULL, which means it may never be empty. Adding a column later changes the table for every row.

## Example

Jack adds a phone column to his customers table. Each old row now has an empty phone until he fills it in.

## Example code

```sql
ALTER TABLE customers ADD COLUMN phone TEXT;
```

Each row in customers now has a phone.

## Why it matters

Columns and their types are what keep data clean. A price can never be the word cheap.

## Common mistake

Storing a list in one column, like phone numbers split by commas. It becomes hard to search and keep right.

## Three principles

- **One kind of fact.** Name, price or date.
- **A set type.** Wrong values are refused.
- **Rules too.** NOT NULL means never empty.

## Related terms

- [Database Table](https://learn.benibix.com/term/development/database-table)
- [Row](https://learn.benibix.com/term/development/row)
- [Data Type](https://learn.benibix.com/term/development/data-type)
- [Database Schema](https://learn.benibix.com/term/development/schema)

---

Source: https://learn.benibix.com/term/development/column
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
