Database Management System (DBMS) / SQL(STRUCTURED QUERY LANGUAGE)

Views in SQL

A view is a virtual table based on a SELECT query.

It doesn’t store data itself, but pulls it dynamically from the original table(s).

Think of it like a saved query you can use like a table!

🧠 Why Use Views?

✅ Simplify complex queries

✅ Enhance data security (hide sensitive columns)

✅ Reuse logic without repeating long queries

✅ Act like a layer between users and raw tables

📌 Example: Create a View for High-Scoring Students

✔️ View acts like a table shortcut

✏️ Update a View

✅ Summary Table

Operation

Command Example

👁️ Create View

CREATE VIEW view_name AS SELECT ...

🧼 Use View

SELECT * FROM view_name;

✏️ Update View

CREATE OR REPLACE VIEW view_name AS SELECT ...