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