Subject Re: [firebird-support] UDF Syntax
Author Helen Borrie
At 09:22 PM 2/09/2004 +0000, you wrote:
>Hi All,
>How do I ALTER the declaration of a UDF? I'm not finding the ALTER
>EXTERNAL FUNCTION command in any of my references.

There isn't one.

>Do you have to
>DROP the UDF first and then DECLARE it agian?


>Also, can you DROP or ALTER a UDF that has dependencies?

What you can do is redeclare the UDF with a different <name> in the DECLARE
EXTERNAL FUNCTION <NAME> clause, alter the dependent SPs to use the new
name, and eventually drop the old declaration when nothing is left that
uses it.