Update-UserDefinedFunction

Updates an existing user-defined function.

Syntax

Update-UserDefinedFunction [-Name] <String> [-SchemaName <String>] [-Definition] <String> [<CommonParameters>]

Updates an existing user-defined function.

Name	Type	Description	Required?	Pipeline Input	Default Value
Name	String	The name of the stored procedure.	true	false
SchemaName	String	The schema name of the stored procedure. Defaults to `dbo`.	false	false	dbo
Definition	String	The store procedure's definition. Everything after the `alter function [schema].[name]` clause.	true	false

Update-UserDefinedFunction -SchemaName 'rivet' 'One' 'returns tinyint begin return 1 end'

Updates a user-defined function to return the number 1.