Sprocs are interpreted at runtime not compiled when you run an alter.

This sucks because you could be joining to that table you just deleted and it won't throw an error upon your alter. You're going to find out the hard way. You'll get an error if you just outright use bad T-SQL, but there is no sanity checking to see if the things you reach out to are there for you.