I tried to drop a function which is used in several views in our system. I have identified many of them by going through the published source code and can drop them so I can subsequently drop the function, but this is a tedious process.

Does anyone know a query to identify the dependencies that prevent the function from being dropped?

try syscat.routinedep