What is a view? Why use it?

A view is a virtual table made up of data from base tables and other views, but not stored separately.

Interview Candidate
Oct 13th, 2004
3
1931

Showing Answers 1 - 3 of 3 Answers

Nimesh

Oct 4th, 2005

every time a view is accessed the data in it is refreshed

vijay saxena

Oct 24th, 2006

a view table is virtual or logical table which depends on base table by using this the filtered records may be accessed frequently.

chandra kanth ganga

Nov 10th, 2006

View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating views while using joins.