Altering a View

—

To change the definition of an existing view, you can use the CREATE OR REPLACE VIEW statement:

CREATE OR REPLACE VIEW view_name AS
SELECT new_column1, new_column2, ...
FROM new_table_name
WHERE new_condition;

Example

CREATE OR REPLACE VIEW employee_view AS
SELECT employee_id, first_name, last_name, salary, department_id
FROM employees
WHERE salary > 50000;

Explanation: This updates the employee_view to include the department_id column and maintains the same salary filter.

Comments