DROP VIEW

DROP VIEW is a SQL statement in the Views category. Removes a view from the database. Does not affect the underlying tables. The syntax is DROP VIEW [IF EXISTS] view_name;. It returns none (view removed). A typical example: DROP VIEW IF EXISTS high_earners; A close relative is CREATE VIEW, which creates a virtual table based on a SELECT query. Think of it as a saved query that acts like a table. A close relative is ALTER VIEW, which modifies an existing view definition. A close relative is MATERIALIZED VIEW, which a view that physically stores the result. Unlike regular views, querying it does NOT re-execute the query. More about this category: Database views — CREATE VIEW, DROP VIEW, ALTER VIEW, materialized views. Related Views entries: CREATE VIEW, ALTER VIEW, MATERIALIZED VIEW, CREATE OR REPLACE VIEW, WITH CHECK OPTION, INDEXED VIEW (WITH SCHEMABINDING), View WITH ENCRYPTION, View WITH READ ONLY.