Dropping a View

To remove a view from the database, you use:

DROP VIEW view_name;

Example:

DROP VIEW employee_view;

Explanation: This command deletes the employee_view from the database, meaning it can no longer be queried or used.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *