Hello Todd, > I would like to add a script that does a "DROP EXTERNAL FUNCTION SQRT". > > The problem I have is that some of the databases that will run this script > already have the UDF dropped and so the script errors. > > Is there a way to run statements like DROP INDEX, DROP EXTERNAL FUNCTION, > etc. in a script without generating an error of the object isn't found?
In a pure SQL script, I wouldn't know. But your application could check if the UDF name exists in RDB$FUNCTIONS and if so, execute DROP EXTERNAL FUNCTION. Cheers, Paul Vinkenoog
