Refresh Views
Brian Donahue
Posts: 6,590 Bronze 1
Hi,
It definitely won't update columns referenced in the view for you. Is that what you're after?
Because using SELECT * shouldn't need to be updated if the referenced table columns change. Is this one of those situations where you need to refresh the view anyway because it is still showing the old columns after updating the database? If so then running sp_refreshview against the view would be the only way to fix it.
It definitely won't update columns referenced in the view for you. Is that what you're after?
Because using SELECT * shouldn't need to be updated if the referenced table columns change. Is this one of those situations where you need to refresh the view anyway because it is still showing the old columns after updating the database? If so then running sp_refreshview against the view would be the only way to fix it.
This discussion has been closed.
