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;