ExecuteSQL to create trigger

Does not need the drop

why is it not called automatically when you paste some code in a method ?