PROCEDURE_OBJECT_ID_UDF (VARCHAR)
Definition
This user-defined function (UDF) checks if a procedure with a specific name has been created before.
PROCEDURE_OBJECT_ID_UDF(NAME VARCHAR) Parameters
NAME VARCHAR
The procedure name to be evaluated.
Returns
Returns a boolean expression depending on the existence of the procedure.
Usage example
Input:
SELECT PROCEDURE_OBJECT_ID_UDF('Test');Output:
FALSELast updated