A view is a logical table based on the result-set of an SQL statement. A view contains no data itself. The fields in a view are fields from one or more real tables in the database. You can add SQL functions to a view, and the view can be used to insert, update or delete data in the real tables. Views are typically used to simplify the complexities of real tables, or to restrict access to data in the underlying tables.Views are a way to logically group data in a database. A view consists of a query that is stored in the database. When you execute the query, the results are displayed as if you had run the query directly on the underlying tables. You can use views to answer specific questions about your data or to generate reports. You can also use views to restrict access to sensitive data by creating a view that only displays the data that you want people to see.Views are a way to logically group columns and rows from one or more tables into a single virtual table. A view contains no data itself, but gets its data "pushed" from the tables that it references when it is queried. Creating a view is therefore very similar to creating a table: CREATE VIEW myview AS SELECT column1, column2 FROM mytable; Views can be created from multiple tables: CREATE VIEW myview AS SELECT column1, column2 FROM mytable1 JOIN mytable2 ON (mytable1.column1 = mytable2.column1);Views are a virtual table based on the result-set of an SQL statement. A view contains no data itself, but is like a window through which data from tables can be seen or changed. Creating a view requires the CREATE VIEW privilege. A user who only has the SELECT privilege for some columns of a table cannot create a view that exposes other columns, unless the owner of the table (or a superuser) grants him the necessary privileges.