title: How do i recreate a trigger in SQL Server?
body: <p>i use the statement <code>drop trigger if exist TRIGGER</code> 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.</p>
  
  <p>How do i do this in SQL server?</p>