drop a Stored Procedure in SQL Server

DROP a Stored Procedure in SQL Server

-- ============================
-- ============================

IF EXISTS (SELECT * FROM DBO.SYSOBJECTs where id = OBJECT_ID(N'[dbo].[sp_Get_XX]')
AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
    DROP PROCEDURE [dbo].[sp_Get_XX]
GO

                                       --OR

IF OBJECT_ID('[dbo].[sp_Get_XX]') IS NOT NULL
    DROP PROCEDURE [dbo].[sp_Get_XX]
GO

                                      --OR

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME = '[dbo].[sp_Get_XX]' AND TYPE = 'P')
            DROP PROCEDURE [dbo].[sp_Get_XX]
GO

                                    -- OR


DROP PROC [dbo].[sp_Get_XX]
ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.