Command
DROP VIEW viewname;Explanation
Drops an existing view from the current database.
Examples
Drop active_users view
DROP VIEW active_users;DROP VIEW viewname;Drops an existing view from the current database.
Drop active_users view
DROP VIEW active_users;