Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (119k points)

Can anyone tell me how to update the view in SQL?

1 Answer

0 votes
by (55.6k points)

You can use either CREATE command or REPLACE VIEW command to update a view in SQL. Here is the syntax to update the view:

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

If you are interested in SQL, then enroll for this SQL Training course by Intellipaat that offers instructor-led training, certification, and job assistance. 

Related questions

0 votes
1 answer
asked Aug 16, 2020 in SQL by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Oct 20, 2020 in SQL by dev_sk2311 (45k points)
0 votes
2 answers
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...