In this blog post, let’s learn about the error message “1047 Request failed. Dependent view view-name exists.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1047 Request failed. Dependent view view-name exists.
Reason for the Error
An object that has a dependent view cannot be dropped unless you use the CASCADE option on the DROP statement.
Solution
To drop the object and all its dependent objects, you can either drop each of the dependent objects using individual DROP statements before dropping the object itself, or use the CASCADE clause on the DROP statement for the object
