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.