A view is a pre-written query that is stored in the database. A view is a SELECT statement, and when you run the light
• Restrict access to specific records in a table
• Restrict access to sure columns in a table
• Present the aggregated information (such as the results of the COUNT function)
• Join columns from multiple tables and present them as if they were part of a single table
A SQL view is a virtual table, which is based on an SQL SELECT query. It is essentially a point of view is close to a table of actual database (no columns and rows like a periodic table), except for the fact that the actual tables store information, while the points of view no. The information view is generated dynamically when the view is referenced. A view refers to two or more tables of existing information bases or other points of view.Indeed every point of view is a filter information table referred to in it and filter it can restrict both the columns and rows of tables of reference.