In this blog post, let’s learn about the error message “3065 The primary key constraint cannot be droppable when the STORE BY PRIMARY KEY clause appears in a table definition.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3065 The primary key constraint cannot be droppable when the STORE BY PRIMARY KEY clause appears in a table definition.
Reason for the Error
You defined a primary key as droppable in a table that includes STORE BY PRIMARY KEY in its definition, which is not supported.
Solution
Change the definition of the primary key constraint so that it is NOT DROPPABLE
