Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010

    Unanswered: Unable to drop function because of dependency

    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?

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    try syscat.routinedep

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts