Join objects and schemas for querying a user-defined function
7> IF EXISTS( SELECT * FROM sys.objects o JOIN sys.schemas s 8> ON o.schema_id = s.schema_id 9> WHERE o.type = 'P' AND 10> s.name = 'Production' AND 11> o.name = 'myProc') 12> DROP PROCEDURE 13> Production.myProc 14> GO