Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

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