Answer: By using count function we can check whether UDF exists or not.Refer below query:-
select count(*)
from sysobjects
where name = 'your_function_name'
and type = 'fn';
Note:- If function exists in the table then count function will return 1 else 0.
Asked In: Many Interviews |
Alert Moderator