15.10 - Differences Between the External and SQL Forms of DROP FUNCTION - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

The syntax and privileges for the external and SQL forms of DROP FUNCTION are the same except that SQL functions do not apply to UDTs or linkage information.

Example: Dropping an SQL Function

These examples drop an SQL function and a specific SQL function.

     DROP FUNCTION udf2 (INTEGER, INTEGER);
     DROP SPECIFIC FUNCTION specific_udf2;

Example: Dropping an External Function by Function Name or Specific Function Name

You can drop a function definition using either its function name or its specific function name. For example, consider the following function definition.

     CREATE FUNCTION Finger_Print_Match(VARBYTE(1000),
     VARBYTE(1000))
       RETURNS INTEGER
       SPECIFIC fpm1
       LANGUAGE C
       NO SQL
       PARAMETER STYLE TD_GENERAL
       EXTERNAL;

Either of the following DROP FUNCTION requests drops its definition, the first using its specific function name and the second using its function name.

     DROP SPECIFIC FUNCTION fpm1;
     DROP FUNCTION Finger_print_Match(VARBYTE, VARBYTE);