Posted by Barry on 01/11/07 16:02

Defaults.

What would a script to look like to do this?

In Oracle I would ALTER TABLE XXX
Modify ( Column default null)

then write a script to fill in XXX from owner_tab_columns where column
exists

Thanks
Barry


Razvan Socol wrote:
> Barry wrote:
> > In sqlserver 2000 I have a UDF which works fine but I want to make a
> > change to it. When I do an ALTER FUNCTION ... I get an error saying
> > that I can't alter the function because it is referenced by an object.
> > Is there any way around this? I reference the UDF in over 100 tables,
> > do I have to go to each table, remove the all references alter the
> > function then edit each 100 tables again? How clumsy can it be?
>
> Yep, that's it. You can generate a script for the drop/recreate of the
> objects that reference the function, using the information from the
> system tables. What kind of objects are we talking about
> (defaults/check constraints/computed columns) ?
>
> Razvan

[Back to original message]