In this post, you’ll learn more about the MariaDB Error 1090 ER_CANT_REMOVE_ALL_FIELDS with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1090 – ER_CANT_REMOVE_ALL_FIELDS with the sqlState 42000
Error Description for the MariaDB Error ER_CANT_REMOVE_ALL_FIELDS
You can’t delete all columns with ALTER TABLE; use DROP TABLE instead