SQL CommandsDDL CommandsViewDROP VIEWOn this pageDROP VIEWDrop the view. Syntax DROP VIEW [ IF EXISTS ] [ <database_name>. ]view_name Examples DROP VIEW IF EXISTS tmp_view;SELECT * FROM tmp_view;ERROR 1105 (HY000): Code: 1025, Text = Unknown table 'tmp_view'.