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