python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions