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...
On this page of the site you can watch the video online Refresh View Definition in SQL Server - SQL Server Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 21 February 2015, share the link with friends and acquaintances, this video has already been watched 8,470 times on youtube and it was liked by 36 viewers. Enjoy your viewing!
