Views that include Select *
mikeATCompuware
Posts: 9
I'm not using the 'Include dependent database objects'. However, I ran into the following situation:
Underlying table changes (column added)
> View references the table with 'Select *' statement, but is not changed
> Another view references first view and does change, to include the column added in the underlying table.
SQL Compare does not recognize that the first view needs to be refreshed so that the update of the second view works correctly.
It would be nice if SQL Compare recognized that the view with 'Select *' needs to be refreshed before updating the 2nd view because the underlying table changed.
-Mike
Underlying table changes (column added)
> View references the table with 'Select *' statement, but is not changed
> Another view references first view and does change, to include the column added in the underlying table.
SQL Compare does not recognize that the first view needs to be refreshed so that the update of the second view works correctly.
It would be nice if SQL Compare recognized that the view with 'Select *' needs to be refreshed before updating the 2nd view because the underlying table changed.
-Mike
Comments
Thanks for contacting us. There does seem to be an issue with the sp_refreshview support when you have nested views.