# DEFAULT Clause

*noun*

say it: **“dih-FAWLT KLAWZ”** **/dɪˈfɔlt klɔːz/**

The part of a SQL column definition that gives the value to use when an INSERT leaves that column out.

## What does **DEFAULT Clause** do in a relational database?

**DEFAULT Clause** — A clause providing a value when an INSERT omits the column.

```sql
CREATE TABLE customer (
    customer_id INTEGER PRIMARY KEY,
    email CHARACTER VARYING(255) NOT NULL,
    status CHARACTER VARYING(20) DEFAULT 'active'
);
```

## In a sentence

- “Without a **DEFAULT clause**, a column the INSERT skips is NULL.”
- “The **DEFAULT clause** on created_at filled in the time for every new row.”

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

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/default-clause
