[MariaDB] Sample - ALTER VIEW

 

Sample Code : ALTER VIEW

# ==============================================================

ALTER VIEW employee_info AS
SELECT employee_id, first_name, last_name, salary, department
FROM employees
WHERE department = 'IT';

# ==============================================================

ALTER VIEW employee_info AS
SELECT e.employee_id, e.first_name, e.last_name, e.salary, d.department_name
FROM employees e
JOIN departments d
ON e.department_id = d.department_id
WHERE e.department = 'IT';