Powered By Blogger

Tuesday, May 24, 2011

What is a view?


View is a logical table which based on one or more than one table or anather view. The table(s) on which view creats are called as base table(s). It does not have it's own data rather it shows the data from the base table(s).

View is a virtual table based on the result set of an SQL statement.It contains rows and columns just like real table.

No comments: