Skip to main content

CREATE, ALTER & DROP VIEW

Learn CREATE, ALTER & DROP VIEW (Views, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A view is a named, stored SELECT . It holds no data of its own; every time you query it, MySQL runs the underlying query. CREATE VIEW defines it, ALTER VIEW (or CREATE OR REPLACE ) changes it, DROP VIEW removes it.

More lessons in Views