How to restore a trigger in SQL Server?

Question

I use the statement drop trigger if exist TRIGGERin sqlite, but the sql server does not like the if statement. (I assume that there is an insulting word). I am doing this right next to my creation of a trigger statement because I want to reset old triggers with the same name so that I can replace it with a new one.

How to do it on a SQL server?

Answer 1

You can check for a specific trigger like this.

IF EXISTS
(
select name
from sys.objects
where type='TR' and name ='Trigger Name'
)
BEGIN

--Add your Trigger create code here

END

Answer 2

SQL Server Management Studio (, , Query Analyzer) Script -as, "Drop Trigger" , SSMS T -SQL, .

, T-SQL, , , .

Answer 3

, SQL Server, MySQL DROP TRIGGER IF EXISTS:

IF OBJECT_ID('XXXX', 'TR') IS NOT NULL
    DROP TRIGGER XXXX

Answer 4

- :

IF objectproperty(object_id('dbo.xxx'), 'isTrigger') = 1
    DROP PROCEDURE dbo.xxx
GO
CREATE TRIGGER dbo.xxx [etc]

xxx ( dbo , ).

ALTER TRIGGER dbo.xxx [etc]