SET SESSION UDFSEARCHPATH SQL Statement | Teradata Vantage - 17.00 - SET SESSION UDFSEARCHPATH - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Allows you to specify a custom UDF search path. When you execute a UDF, Vantage searches this path first, before looking in the default Vantage search path for the UDF.

If you have created your own UDF that has the same name as a Vantage system UDF, you can use this statement to ensure Vantage executes your UDF, rather than the Vantage system UDF.

For more information about creating UDFs, see Teradata Vantage™ - SQL External Routine Programming , B035-1147 .


You must have access to any database you specify as part of the UDF search path.