rename and reorder the columns. change ORDER BY clause. drop and create the view in a single transaction block.