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

Refresh Views

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 23, 2004 4:42PM in SQL Compare Previous Versions

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.