Altering a Function that is used in a computed column
Posted on 2010-01-11
I have a question that I have never been asked by anyone before and wanted to get the experts answers here.
I have a table, and one of the columns is a computed column using a function. Now it is time to change the function body to include more criteria, etc. But because it is a function that is used in a computed column, SQL will not let me alter the function.
How is it that you can alter the function for new functionality for the computed column?