Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

The syntax for altering a simple table-valued function

ALTER FUNCTION [owner_name.]function_name     ([@parameter_name data_type [= default]] [, ...]) RETURNS TABLE [WITH {ENCRYPTION|SCHEMABINDING|ENCRYPTION,SCHEMABINDING}] RETURN [(] select_statement [)]