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...
En esta página del sitio puede ver el video en línea Refresh View Definition in SQL Server - SQL Server Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario TechBrothersIT 21 febrero 2015, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 8,470 veces y le gustó 36 a los espectadores. Disfruta viendo!
