DROP VIEW

SQL DROP VIEW Keyword

The DROP VIEW command deletes a view from the database.

SQL DROP VIEW Syntax

DROP VIEW view_name

DROP VIEW view_name

SQL DROP VIEW Example

Before you can drop a view, you must first create it. In our TechKubo playground, views are not permanent — they are deleted when the browser or tab is refreshed. Below is a full example of how to create and drop a view using the Patients table:

Step 1: Create a View (must be done in the same session)

CREATE VIEW FemalePatientNames AS
SELECT first_name, last_name
FROM Patients
WHERE gender = 'F'

CREATE VIEW FemalePatientNames AS

SELECT first_name, last_name

FROM Patients

WHERE gender = 'F'

Step 2: Drop the View

DROP VIEW FemalePatientNames

DROP VIEW FemalePatientNames

SQL DROP VIEW Labs