# Column Alias

*noun*

say it: **“KOL-um AY-lee-us”** **/ˈkɒləm ˈeɪliəs/**

A temporary name given to a column or calculated value in a query's results, written with AS.

## What is **Column Alias** in a relational database?

**Column Alias** — A temporary output name assigned to a selected expression or column.

```sql
SELECT total_amount AS order_total
FROM purchase_order;
```

## In a sentence

- “I gave the total a **column alias**, AS StockValue, so the result has a clear heading.”

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

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/column-alias
