What is a database view and why do we use it?
view is a virtual table created by querying data from one or more tables. It does not store
data itself but presents it in a specific format.
Use cases:
- Simplify complex queries: A view can encapsulate complex queries for easier
reuse.
- Data security: Views can restrict access to certain columns or rows for users without
giving them full table access.