asked on VB.net SQL Views don't incorporate new columns added to a table
Hi
I have a number of Views in my SQL 2014 database that pull data from a number of tables. If I add new columns to one of the tables then run my application that reads the database schema to show all columns from the table doesn't update. Is this because the schema in the database hasn't been updated?
Is there a way to refresh all views so that they bring in new columns?
I have a number of Views in my SQL 2014 database that pull data from a number of tables. If I add new columns to one of the tables then run my application that reads the database schema to show all columns from the table doesn't update. Is this because the schema in the database hasn't been updated?
Is there a way to refresh all views so that they bring in new columns?
Microsoft SQL ServerVisual Basic.NET
Last Comment
Murray Brown
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
sp_refreshview does NOT add new columns. As it says in the MSDN article it only refreshes the metadata for the view (column data type change or relationships changes for example).
I mean if the user added new columns in the table and if you have "SELECT *" in the view then one has to
use below to get the new column from the view.
EXECUTE sp_refreshview N'ViewName';
It is one of the famous limitation of the views
use below to get the new column from the view.
EXECUTE sp_refreshview N'ViewName';
It is one of the famous limitation of the views
It is one of the famous limitation of the viewsFamous? What are the others limitations?
ASKER
Thanks very much
EXECUTE sp_refreshview N'ViewName';