steve.casey (7/2/2012)
Some of us have to work with versions older than SS 2005, you know! DROP...CREATE is the only one that will work with ALL versions.
That's what I thought too... of course I don't write many views.... tables yes... stored procs yes...... views.... rarely.
That said, I had to find out what the heck sp_refreshview was if it existed... and it changed my answer. 🙂
Yay +1