How do i recreate a trigger in SQL Server?
Posted
by acidzombie24
on Stack Overflow
See other posts from Stack Overflow
or by acidzombie24
Published on 2010-05-19T14:04:43Z
Indexed on
2010/05/19
14:20 UTC
Read the original article
Hit count: 121
Filed under:
sql-server
|triggers
i use the statement drop trigger if exist TRIGGER in sqlite but sql server doesnt like the if statement. (i guess exist is the offending word). I do this right next to my create trigger statement because i want to drop older triggers with the same name so i can replace it with this new one.
How do i do this in SQL server?
© Stack Overflow or respective owner
