Dropping a Trigger

You must drop and re-create the trigger if you rename any of the objects referenced by the trigger.

You can rename a trigger with sp_rename.

When you drop a table, any triggers associated with it are also dropped.