SQL VIEW – Process Description
A VIEW is a virtual table created from a SQL query. It does not store data itself; it shows data from one or more tables dynamically.
1. What is a VIEW?
A saved SELECT query
Acts like a table when queried
Data is always up-to-date with the base tables
2. VIEW Creation Process
Step 1: Write a SELECT query
SELECT student_id, student_name, class
FROM students
WHERE status = 'Active';
Step 2: Create the VIEW
CREATE VIEW active_students AS
SELECT student_id, student_name, class
FROM students
WHERE status = 'Active';
3. How VIEW Works Internally