Why do we create the view?

Why do we create views?

Views can be used for a few reasons. Some of the main reasons are as follows: To simplify database structure to the individuals using it. As a security mechanism to DBAs for allowing users to access data without granting them permissions to directly access the underlying base tables.

What does create a view mean?

Purpose. Use the CREATE VIEW statement to define a view, which is a logical table based on one or more tables or views. A view contains no data itself. The tables upon which a view is based are called base tables.

What happens when you create a view?

What actually happens in the database when you create a view, and what happens when you use it? association with the underlying tables. In other words, creating a view does not generate a copy of the data, neither at the time the view is defined nor at the time the view is accessed.

Why do we use views in database?

Views can join and simplify multiple tables into a single virtual table. Views can act as aggregated tables, where the database engine aggregates data (sum, average, etc.) and presents the calculated results as part of the data. Views can hide the complexity of data.