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

Refresh Views

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 23, 2004 4:42PM in SQL Compare Previous Versions
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.
This discussion has been closed.