What are the challenges you face when working across database platforms? Take the survey

Views that include Select *

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.



Sign In or Register to comment.