ALTER FUNCTION SQL Statement | Teradata Vantage - ALTER FUNCTION - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
ft:locale
en-US
ft:lastEdition
2021-07-27
dita:mapPath
spp1591731285373.ditamap
dita:ditavalPath
spp1591731285373.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantageā„¢
Performs either or both of the following functions.
  • Controls whether an existing function can run in protected mode as a separate process or in unprotected mode as part of the database.
  • Recompiles C or C++ functions or relinks Java functions and redistributes them.
Java UDFs must always run in protected mode, so you cannot use this statement to change their protection mode.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

To alter a function definition, you must have the ALTER FUNCTION privilege on that function.

There are no privileges granted automatically.