• This is why one must be very careful with the SELECT * approach. Since you will have to run a refresh of the view, I find it less potentially confusing to simply list out the column names in the Select clause. Any column addition means you add your new column to the view definition with no fancy extra steps to consider (like whats that refresh stored proc again?). A simple straight forward approach instead.

    I think there is the temptation to shirk here when the number of columns to list out is great. There are add on tools that can help in this regard. In fact, if you just drag over the columns folder from the object explorer window in SSMS, it will spell all of these out for you.

    ----------------------------------------------------