the difference:
1. Views are already compiled SQL statements; tables are not.
2. The view has no actual physical records; but the table has it.
3. View is window; table is content
4. Peugeot uses physical space while views do not occupy physical space. Views are just logical concepts. Even if tables can be modified, views can only have created statements to modify.
5. It indicates the inner mode, and the view is the outer mode.
6. View is a way to view data tables. You can query the data composed of certain fields in the data table, just a collection of some SQL statements. From a security perspective, the view can not give users contact with the data table, thus not knowing the table structure.
7. A table belongs to a table in the global mode and is a real table; a view belongs to a table in the local mode and is a virtual table.
8. The creation and deletion of views only affect the view itself and not the corresponding basic table.
Contact: A view is a table created on top of a base table. Its structure (i.e. all defined columns) and content (i.e. all data rows) come from the base table, and it exists based on the existence of the base table. A view can correspond to one basic table or multiple basic tables. Views are abstractions of basic tables and new relationships established in a logical sense.