|
gregoryagu
Yak Posting Veteran
76 Posts |
 Posted - 07/31/2008 : 17:21:57
|
--Drops a Procedure if it exists and prints a message with the result.
CREATE PROCEDURE [dbo].[Utils_DropProcedure]
(
@ProcedureName varchar(128)
)
AS
BEGIN
Declare @SQL varchar(4000)
set @SQL = 'IF (EXISTS (SELECT * FROM dbo.sysobjects '
+ ' WHERE id = OBJECT_ID('''
+ @ProcedureName + ''') AND OBJECTPROPERTY(id,''IsProcedure'') = 1))'
+ 'BEGIN PRINT ''Dropping the Procedure:'' PRINT '''
+ @ProcedureName + ''' DROP PROCEDURE ['
+ @ProcedureName + '] END ELSE BEGIN PRINT ''Procedure Not Found:'''
+ 'Print ''' + @ProcedureName + ''' END'
EXECUTE (@SQL)
END
GO |
|
Drop Procedure If It Exists
