MariaDB Error 1853 – ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK

In this post, you’ll learn more about the MariaDB Error 1853 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK with the details of the error message and why you receive this error

Maria DB Error Description

MariaDB Error 1853 – ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK with the sqlState HY000

Error Description for the MariaDB Error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK

Dropping a primary key is not allowed without also adding a new primary key