Sample Header Ad - 728x90

Scalar function used in calculated column, what's the cleanest way to update the function?

10 votes
2 answers
1863 views
I want to update a scalar function in our database. This function is used for several calculated columns in a key table so I get a dependency error if I try to update it. I can explicitly remove the columns, update the function and re-add the columns but, without a lot of extra fannying about, that will change column orders and might have other unintended consequences. I wondered if there was a cleaner way of doing it?
Asked by robertc (317 rep)
Mar 22, 2012, 11:31 AM
Last activity: Aug 5, 2025, 04:20 AM