How to Modify a View
To change a View, you can replace it.
Option 1: DROP and CREATE
DROP VIEW active_students;
CREATE VIEW active_students AS
SELECT student_id, name, grade, age
FROM students
WHERE is_active = TRUE;Option 2: CREATE OR REPLACE
CREATE OR REPLACE VIEW active_students AS
SELECT student_id, name, grade, age
FROM students
WHERE is_active = TRUE;Easier! Replaces if exists, creates if not.
Summary
Modify View = Replace it Use CREATE OR REPLACE for easy updates