How we can update the view?

Category: SQLHow we can update the view?
Editor">Editor Staff asked 2 years ago

How we can update the view?

1 Answers
Editor">Editor Staff answered 2 years ago

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