How to check whether user defined function(UDF) is there in table or not?

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 1353 | Points: 40
Answer:

Use below query to check for function:-
if exists(select name from sysobjects where name = 'your_function_name' and type = 'fn')

begin
print 'exists';
end
else
begin
print 'not exists';
end;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response