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
Last activity: Aug 5, 2025, 04:20 AM