Example of RECREATE VIEW
Creating the new view
PRICE_WITH_MARKUP
view or recreating it, if it already existsRECREATE VIEW PRICE_WITH_MARKUP (
CODE_PRICE,
COST,
COST_WITH_MARKUP
) AS
SELECT
CODE_PRICE,
COST,
COST * 1.15
FROM PRICE;