replaced http://stackoverflow.com/ with https://stackoverflow.com/
Source Link

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.

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-view which shows how to use ALTER VIEW rather than DROP VIEW and CREATE VIEW in order to do things like preserve permissions.

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 https://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.

Post Migrated Here from stackoverflow.com (revisions)
Source Link

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-view which shows how to use ALTER VIEW rather than DROP VIEW and CREATE VIEW in order to do things like preserve permissions.