You are here: Home > Technical Articles > MS SQL Server - Drop Trigger If Exists
SQL Script for dropping trigger if it exists in the database
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'tr_order_number_ins' AND type = 'TR')
BEGIN
DROP TRIGGER tr_order_number_ins
END
GO
Published On: 02 Aug 2009
MS Sql Server - Drop Trigger If Exists
SQL Script for dropping trigger if it exists in the database
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'tr_order_number_ins' AND type = 'TR')
BEGIN
DROP TRIGGER tr_order_number_ins
END
GO
Published On: 02 Aug 2009
