1. Back To Blog

SQL Server interview questions :- Explain Views and is it possible to update views ?

Do not miss to watch SQL Server Interview Questions video with sample answers :-

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