View vs table)

Differences

1. views are compiled SQL statements, but tables are not.

2. The view does not have an actual physical record, but the table does.

3. The view is a window, and the table is content.

4. Peugeot uses physical space, while a view does not occupy physical space. A view only exists as a logical concept. A table can be modified only by creating statements.

5. indicates the internal mode. The view is the external mode.

6. view is a way to view data tables. You can query data composed of certain fields in a data table, but only a set of SQL statements. In terms of security, a view does not expose users to data tables, so they do not know the table structure.

7. A table is a table in global mode and a real table. A view is a table in local mode and a virtual table.

8. Creating and deleting a view only affects the view and does not affect the corresponding basic table.

Contact: A view is a table created on top of a basic table. Its structure (that is, all defined columns) and content (that is, all data rows) come from the basic table, it exists based on the basic table. A view can correspond to one basic table or multiple basic tables. A view is the abstraction of a basic table and the new relationship established in a logical sense.

View vs table)