Can we update view in SQl

AnswerBot
11mo

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
author
11mo

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...
Top Lionbridge Technologies Senior Database Developer interview questions & answers
Popular interview questions of Senior Database Developer
>
Lionbridge Technologies Senior Database Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app