SQL Server interview questions :- Explain Views and is it possible to update views ?
View Is Virtual table over 1 or more physical tables.
There are two types of views :-
1. Simple view :- Simple views are create on single physical base table. Simple views can be updated as they have only one base table internally.
2. Complex view :- Complex views are created on multiple physical tables by using a SQL query. Complex view are readonly and we can not perform DML operation on the same.
Below is a nice video which explains views and also demonstrates nitty gritty about updatable views.