Drop an Existing View in MySQL

Q

How To Drop an Existing View in MySQL?

✍: FYIcenter.com

A

If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script:

mysql> DROP VIEW faqComment;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM faqComment;
ERROR 1146 (42S02): Table 'fyi.faqcomment' doesn't exist

 

⇒CREATE, ALTER and DROP Statements in MySQL

⇒⇒MySQL Database Tutorials

2018-01-24, 393👍, 0💬

General MySQL Oracle SQL Server