Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

The syntax for altering a multi-statement table-valued function

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