You may come across a time when you want to INSERT additional records into a table. But the INSERT statement may have been using a TRIGGER, which may affect other tables. In this scenario, you can use enable/disable properties of the trigger rather than deleting and re-creating it again. Just use the following:

ALTER TABLE yourtablename DISABLE TRIGGER ALL

--Here write your additional script

ALTER TABLE yourtablename ENABLE TRIGGER ALL