• I like to practice "defensive" programming and so I want the system to fail if I accidentally hit "execute".
    Just having CREATE prevents this accidentally replacing the original version unless I deliberately change it to say ALTER.

    Me, too. Having a CREATE OR ALTER statement does not give me a good feeling.