# MySQL ERROR 1091 (42000): Can't DROP 'x'; check that column/key exists

**Code:** `1091` · **Category:** MySQL · **Seen on:** MySQL

ALTER TABLE tried to drop a column or index that doesn’t exist.

## Meaning

Migrations running twice or written against a different schema version.

## Common causes

- Already dropped
- Different name in this environment

## Quick fix

1. Check SHOW CREATE TABLE
2. Make migrations idempotent

## Detailed fix by platform

### MySQL

1. `SHOW CREATE TABLE orders\G`

## How to diagnose

1. **Object** — Exists under that name?
2. **Recent change** — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/mysql/1091-cant-drop-check-exists)
