1. Back To Blog

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.


Shiv Prasad Koirala

Visit us @ www.questpond.com or call us at 022-66752917... read more

We are on Social