In this blog post, let’s learn about the error message “20230 You cannot drop all partitions of the table or index. At least one partition must remain.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20230 You cannot drop all partitions of the table or index. At least one partition must remain.
Reason for the Error
You tried to drop the only remaining partition of a table or index.
Solution
If you want to drop the last remaining partition, use the DROP TABLE or INDEX statement
