In this blog post, let’s learn about the error message “1048 The statement currently supports only RESTRICT drop behavior.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1048 The statement currently supports only RESTRICT drop behavior.
Reason for the Error
Drop behavior CASCADE was specified on a DROP statement that supports only RESTRICT drop behavior.
Solution
Reissue the DROP statement, specifying RESTRICT or omitting the drop behavior (which will default to RESTRICT)
