Page History

...

Their DDLs are “CREATE/DROP TEMPORARY FUNCTION”.

"SHOW FUNCTIONS" - list names of (temp and non-temp ) system/built-in functions, and names of temp and catalog functions in the current catalog and db

"SHOW ALL FUNCTIONS" - list names of (temp and non-temp ) system/built functions, and fully qualified names of temp and catalog functions in all catalog catalogs and db dbs

"SHOW ALL TEMPORARY FUNCTIONS" - list names of all fully fully qualified names of temp and catalog functions in all catalog and db 

"SHOW ALL TEMPORARY SYSTEM FUNCTIONS" - list names of all temp system functions

...