Views

A view is something of a virtual table. A view, for the most part, is used just like a table, except that it doesn’t contain any data of its own. The difference between a view and a table is that views are definitions built on top of other tables (or views), and do not hold data themselves. Instead, a view is merely a pre planned mapping and representation of the data stored in tables. You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.


create view productlist

select productid ,productname 

from products



see more information plz visit