# Schema

*noun*

say it: **“SKEE-muh”** **/ˈskimə/**

The planned structure of a database's data: which tables or fields exist, what each holds and how they relate.

## What is **Schema** in a relational database?

**Schema** — The named structure defining database objects such as tables, views, and constraints.

```sql
CREATE SCHEMA sales;
```

## In a sentence

- “MongoDB doesn't force one **schema** on a collection, though validation can add one.”
- “Adding a column changes the table's **schema**, so every row gets it.”

Level: Novice · [More Database terms at this level](https://www.ask-codey.com/glossary?category=database&level=1)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/schema
