Yes, that's exactly what you have to do.
>Hi All, I have a udf which I use as a default value in several tables in my database - if I try to modify the udf I receive the error cannot modify ... etc... as it is being referenced by mytable... - do I have to modify all the tables and remove the reference before I can make the change ? I hope not !!!
--sb--