In this blog post, let’s learn about the error message “1136 For an added column, the PRIMARY KEY clause cannot specify NOT DROPPABLE.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1136 For an added column, the PRIMARY KEY clause cannot specify NOT DROPPABLE.
Reason for the Error
You used the ALTER TABLE statement to add a column specifying a primary key that is not droppable. A primary key added through ALTER TABLE must be droppable.
Solution
Change the ALTER TABLE statement to specify DROPPABLE for the primary key
