# Syntax error because a reserved keyword (order, group, user, key) is used as a column or table name

**Code:** `reserved word` · **Category:** SQL · **Seen on:** SQL, MySQL, PostgreSQL

A column or table is called something the SQL grammar reserves, so the parser fails near it.

## Meaning

Words like `order`, `group`, `user`, `key`, `desc`, `table`, `limit` need quoting (`"order"`, `` `order` ``, `[order]`) or renaming. Renaming (`orders`, `order_status`) is the safest long-term fix.

## Common causes

- Table named `order` or `user`
- Column called `group`, `key` or `desc`
- Unquoted reserved word in an INSERT column list
- ORM/DDL generated without quoting
- Dialect-specific reserved lists differ

## Quick fix

1. Quote the identifier for your dialect
2. Rename the column/table
3. Check the database's reserved word list

## Detailed fix by platform

### SQL

1. 

```sql
SELECT "order".id FROM "order";   -- PostgreSQL/SQLite
SELECT `order`.id FROM `order`;  -- MySQL
```


## How to diagnose

1. **Name** — Reserved word?
2. **Quoting** — Applied?
3. **Rename** — Possible?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/reserved-keyword-used-as-identifier)
