Cacher is the code snippet organizer for pro developers

CREATE VIEW view_name AS query;

-- example
CREATE VIEW customer_info AS 
SELECT first_name, last_name, email, address, phone
FROM customer
JOIN address
ON customer.address_id = address.address_id;

-- Renaming a view
ALTER VIEW customer_info RENAME TO customer_master_list;

-- Deleting a view
DROP VIEW IF EXISTS customer_master_list;