# Database Table

> One kind of data in a database. It is set out in rows and columns.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** Table, SQL Table

## Think of it like

Think of it like a class list. Each pupil gets a line, and each line has the same boxes to fill.

## Definition

A table is where a database keeps one kind of thing, like customers or orders. It has columns, which say what each record holds, and rows, which are the records. Every row in a table has the same columns. A database usually has many tables that point to each other. Choosing good tables is the first step in designing a database.

## Example

Jack's shop has a customers table and an orders table. Each order row points to the customer who placed it.

## Example code

```sql
CREATE TABLE customers (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  city TEXT
);
```

A table with three columns, ready for rows.

## Why it matters

Tables give data a fixed shape. That shape is what makes searching and checking it reliable.

## Common mistake

Putting all your data in one huge table. Orders, customers and products each want their own.

## Three principles

- **One kind of thing.** Customers here, orders there.
- **Same columns.** Every row has the same boxes.
- **Tables link up.** Keys point from one to another.

## Related terms

- [Row](https://learn.benibix.com/term/development/row)
- [Column](https://learn.benibix.com/term/development/column)
- [Primary Key](https://learn.benibix.com/term/development/primary-key)
- [Database Schema](https://learn.benibix.com/term/development/schema)

## Told apart from

- [Database View vs Database Table](https://learn.benibix.com/compare/database-view-vs-database-table): People think a view is a copy of a table, and it is not. A table holds rows of its own on disk. A view holds no rows at all. It is a saved query with a name, and it runs fresh each time you read it. Change a row in the table, and the view shows the change at once.

---

Source: https://learn.benibix.com/term/development/database-table
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.
