Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

The syntax of the ALTER FUNCTION statement for a scalar valued function

ALTER FUNCTION [owner_name.]function_name     ([@parameter_name data_type [= default]] [, ...]) RETURNS data_type [WITH {ENCRYPTION|SCHEMABINDING|ENCRYPTION,SCHEMABINDING}] BEGIN     [sql_statements]     RETURN scalar_expression END