How we can update the view?

SQL - Interview Questions

SQL CREATE and REPLACE can be used for updating the view.

Execute the below query to update the created view.

Syntax:

CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

More Technologies Interview Questions