View not refreshed after table change
AdamRink
Posts: 13
Is there a way to refresh views after altering table schema?
We have a table change that adds columns to the table. Then later in the deployment script a new proc is added that reads the view of the table we just altered. The view has not been refreshed; and the proc cannot be created because the columns do not exist.
We have a table change that adds columns to the table. Then later in the deployment script a new proc is added that reads the view of the table we just altered. The view has not been refreshed; and the proc cannot be created because the columns do not exist.
Comments
Thanks for posting!
I have followed up with you via email for further troubleshooting.
Kind Regards,
Technical Sales Engineer
Redgate Software