Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Computed Columns from UDFs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-21 : 11:22:05
Sherri writes "Is there a way from T-SQL to clear the formula for a column that is defined as a computed column using a User Defined Function

Background...I have several UDF's that are formulas in several tables. When I need to update the production database from the developement database and try to drop and recreate the user defined functions, I get an error because they are tied to these columns. I have no way of knowing if these user-defined functions have been modified by one of the development team and would always like to drop and recreate them when upgrading the production database.

Thanks in advance."
   

- Advertisement -