How to drop VIEW in MySQL ?

MySQL Drop VIEW

You can drop the VIEW by using the DROP VIEW statement.

Syntax:
DROP VIEW [IF EXISTS] view_name; 
Parameters:
view_name: It specifies the name of the VIEW that you want to drop.
IF EXISTS: It is optional. If you do not specify this clause and the VIEW doesn't exist, the DROP VIEW statement will return an error.

Example:
DROP VIEW trainer;

To see the dropped VIEW(It will never found):
Syntax:
SELECT * FROM view_name; 

Return empty***

Subscribe channel on YouTube
Read this post on Blogger
Like page on Facebook
Tweet about video on twitter
Let's chat on whatsapp
See you at Instagram