HPE NonStop SQL/MX Error – 1136 For an added column, the PRIMARY KEY clause cannot specify NOT DROPPABLE.

Data 18 Views 1 Min Read

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

Tags: