• Don't forget that when you do schema changes to underlying tables your should do sp_refreshview on the dependent views.

    It is worth mentioning the WITH CHECK option. If you have an updateable view with a WHERE clause in it the option prevents you inserting data that would conflict with the WHERE clause