A view is a virtual table.
SQL CREATE VIEW
A view is a virtual table based on the result of a query (SELECT) to a table.
The view always show actual data from one or more tables.
Each time a user question and a view, the system database, updates the view to always display actual data.
Example SQL CREATE VIEW
In the table people
We create a view with the people who call Harry
For data in a view
At the hearing [people called HARRY] we have the following data:
SQL REPLACE VIEW
To replace or modify data in a view:
SQL DROP VIEW
To delete a view
Example Removal seen before created