Sql Query to Delete or Drop View


SQL View is an imaginary view table based on information retrieved using a select query.

Suppose a user wants to delete or drop an already existing view.

Then he can use below DROP query

Enter - Select * from table_name;
SQL Query
CREATE VIEW usersalary_view AS SELECT * FROM employees as e INNER JOIN job_history as jh WHERE e.employee_id = jh.employee_id; SELECT * FROM usersalary_view; SELECT 'After view drop'; DROP VIEW usersalary_view; SELECT * FROM usersalary_view;
Output