Refresh View Definition in SQL Server - SQL Server Tutorial
In this video we will learn how to refresh the definition of a view. When you use Select * in the view definition and columns will be added to base table/s later, the view will present the columns those were available at point of view creation. It will not include newly columns even you are using "*" in your query.
To include those columns in the view, we need to refresh the view definition after adding column/s to table/s. Below script can be used to learn step by step how this works and finally refresh the view by using sp_refreshview stored procedure.
link for blog with scripts used in the video
http://sqlage.blogspot.com/2015/02/re...
Nesta página do site você pode assistir ao vídeo on-line Refresh View Definition in SQL Server - SQL Server Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário TechBrothersIT 21 Fevereiro 2015, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 8,470 vezes e gostou 36 espectadores. Boa visualização!
