I highly recommend not using
SELECT * in code embedded... well... pretty much anywhere. The fields of the view are being defined when the view is created. You need to recreate the view.
Also, look at the accepted answer to http://stackoverflow.com/questions/163246/sql-server-equivalent-to-oracles-create-or-replace-viewhttps://stackoverflow.com/questions/163246/sql-server-equivalent-to-oracles-create-or-replace-view which shows how to use
ALTER VIEW rather than
DROP VIEW and
CREATE VIEW in order to do things like preserve permissions.