HPE NonStop SQL/MX Error – 3054 The NOT DROPPABLE clause is allowed only in PRIMARY KEY and NOT NULL constraint definitions.

In this blog post, let’s learn about the error message “3054 The NOT DROPPABLE clause is allowed only in PRIMARY KEY and NOT NULL constraint definitions.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3054 The NOT DROPPABLE clause is allowed only in PRIMARY KEY and NOT NULL constraint definitions.

Reason for the Error

You specified a constraint with an invalid NOT DROPPABLE clause, which can appear only in PRIMARY KEY and NOT NULL constraint definitions.

Solution

Correct the syntax and resubmit