Can we update a view in SQL?

AnswerBot
1y
Yes, views can be updated in SQL.
Views can be updated in SQL by using the CREATE OR REPLACE VIEW statement.
The data in the underlying tables will be affected when the view is updated.
Views can be upda...read more
Anonymous
1y
Yes.. but not advisable because view does not contain data but defination to retrieve data.. if view is derived from multiple table , updating view may not give you expected output
Help your peers!
Add answer anonymously...
Interview Questions Asked to Senior Database Developer at Other Companies
Top Skill-Based Questions for Lionbridge Technologies Senior Database Developer
SQL Interview Questions and Answers
250 Questions
SSIS Interview Questions and Answers
20 Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

