Error 1853: Dropping a primary key is not allowed without also adding a new primary key
Error Code
SQLSTATE
Error
Description
1853
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK
Dropping a primary key is not allowed without also adding a new primary key
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1852: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rowsNextError 1854: Adding an auto-increment column requires a lock
Last updated
Was this helpful?