Example Of

Creating the new view PRICE_WITH_MARKUP view or altering it if it already exists

CREATE OR ALTER VIEW PRICE_WITH_MARKUP (
  CODE_PRICE,
  COST,
  COST_WITH_MARKUP
) AS
SELECT
  CODE_PRICE,
  COST,
  COST * 1.15
FROM PRICE;

`DROP VIEW`

Drops a view

Available in

DSQL

Syntax

DROP VIEW viewname

Table 1. `DROP VIEW` Statement Parameter
Parameter	Description
viewname	View name

The DROP VIEW statement drops (deletes) an existing view.The statement will fail if the view has dependencies.